{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["APU Profile Form","checklist","Roster","APU Master","FY24-FY25 Scales","APU Scale"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":9,"defined_names":129,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"APU Profile Form","index":0,"n_rows":178,"n_cols":14,"rows_kept":178,"cut":false,"hidden":false,"merged":[[2,3,2,8],[4,3,4,8],[6,3,6,8],[8,3,8,8],[11,2,19,10]]}
[]
[]
[null,null,"DEPARTMENT:",{"$f":"Roster!C10","v":0}]
[]
[null,null,"APU NAME:",{"$f":"VLOOKUP(D7,'APU Master'!B:D,3,FALSE)","v":0}]
[]
[null,null,"APU CODE:",{"$f":"Roster!A10","v":0}]
[]
[null,null,"DATE SUBMITTED:",{"$f":"TODAY()","v":"2025-12-18"}]
[]
[null,null,"Description of APU:  Please include criteria used."]
[null,null,{"$f":"VLOOKUP(D7,'APU Master'!B:E,4,FALSE)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"PROPOSED HEALTH SCIENCES SALARY SCALE:"]
[null,null,"(Using Scale pay numbers: 1 thru 9. Insert Scale pay number assigned to APU for each of 5 future years.)"]
[]
[null,null,null,"2025-07-01",{"$f":"Roster!B10","v":0},"2026-07-01",{"$f":"E25","v":0},"2027-07-01",{"$f":"G25","v":0}]
[]
[null,null,null,"2028-07-01",{"$f":"I25","v":0},"2029-07-01",{"$f":"E27","v":0}]
[]
[]
[]
[null,null,"APU Membership:"]
[null,null,"(Use current established Scale Pay rates at the time of the submission. DO NOT USE blended FY pay rates. Attach another sheet if necessary.)"]
[]
[null,null,null,null,null,"X Salary","X' Salary","Off-Scale Salary","Total Covered Comp","Y Salary","Total Negotiated"]
[null,null,"Name","Rank","Step","Annual Rate","Annual Rate","Annual Rate","Annual Rate","Annual Rate","Annual Rate",null,"X","X'"]
[null,null,{"$f":"Roster!D10","v":0},{"$f":"Roster!E10","v":0},{"$f":"Roster!F10","v":0},{"$f":"Roster!K10","v":0},{"$f":"Roster!L10","v":0},{"$f":"Roster!M10","v":0},{"$f":"F36+G36+H36","v":0},{"$f":"Roster!O10","v":0},{"$f":"I36+J36","v":0}]
[null,null,{"$f":"Roster!D11","v":0},{"$f":"Roster!E11","v":0},{"$f":"Roster!F11","v":0},{"$f":"Roster!K11","v":0},{"$f":"Roster!L11","v":0},{"$f":"Roster!M11","v":0},{"$f":"F37+G37+H37","v":0},{"$f":"Roster!O11","v":0},{"$f":"I37+J37","v":0},null,193800,19400]
[null,null,{"$f":"Roster!D12","v":0},{"$f":"Roster!E12","v":0},{"$f":"Roster!F12","v":0},{"$f":"Roster!K12","v":0},{"$f":"Roster!L12","v":0},{"$f":"Roster!M12","v":0},0,{"$f":"Roster!O12","v":0},0,null,166300,16600]
[null,null,{"$f":"Roster!D13","v":0},{"$f":"Roster!E13","v":0},{"$f":"Roster!F13","v":0},{"$f":"Roster!K13","v":0},{"$f":"Roster!L13","v":0},{"$f":"Roster!M13","v":0},0,{"$f":"Roster!O13","v":0},0,null,133900,13400]
[null,null,{"$f":"Roster!D14","v":0},{"$f":"Roster!E14","v":0},{"$f":"Roster!F14","v":0},{"$f":"Roster!K14","v":0},{"$f":"Roster!L14","v":0},{"$f":"Roster!M14","v":0},0,{"$f":"Roster!O14","v":0},0,null,108900,10900]
[null,null,{"$f":"Roster!D15","v":0},{"$f":"Roster!E15","v":0},{"$f":"Roster!F15","v":0},{"$f":"Roster!K15","v":0},{"$f":"Roster!L15","v":0},{"$f":"Roster!M15","v":0},0,{"$f":"Roster!O15","v":0},0,null,108900,10900]
[null,null,{"$f":"Roster!D16","v":0},{"$f":"Roster!E16","v":0},{"$f":"Roster!F16","v":0},{"$f":"Roster!K16","v":0},{"$f":"Roster!L16","v":0},{"$f":"Roster!M16","v":0},0,{"$f":"Roster!O16","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D17","v":0},{"$f":"Roster!E17","v":0},{"$f":"Roster!F17","v":0},{"$f":"Roster!K17","v":0},{"$f":"Roster!L17","v":0},{"$f":"Roster!M17","v":0},0,{"$f":"Roster!O17","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D18","v":0},{"$f":"Roster!E18","v":0},{"$f":"Roster!F18","v":0},{"$f":"Roster!K18","v":0},{"$f":"Roster!L18","v":0},{"$f":"Roster!M18","v":0},0,{"$f":"Roster!O18","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D19","v":0},{"$f":"Roster!E19","v":0},{"$f":"Roster!F19","v":0},{"$f":"Roster!K19","v":0},{"$f":"Roster!L19","v":0},{"$f":"Roster!M19","v":0},0,{"$f":"Roster!O19","v":0},0,null,108900,10900]
[null,null,{"$f":"Roster!D20","v":0},{"$f":"Roster!E20","v":0},{"$f":"Roster!F20","v":0},{"$f":"Roster!K20","v":0},{"$f":"Roster!L20","v":0},{"$f":"Roster!M20","v":0},0,{"$f":"Roster!O20","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D21","v":0},{"$f":"Roster!E21","v":0},{"$f":"Roster!F21","v":0},{"$f":"Roster!K21","v":0},{"$f":"Roster!L21","v":0},{"$f":"Roster!M21","v":0},0,{"$f":"Roster!O21","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D22","v":0},{"$f":"Roster!E22","v":0},{"$f":"Roster!F22","v":0},{"$f":"Roster!K22","v":0},{"$f":"Roster!L22","v":0},{"$f":"Roster!M22","v":0},0,{"$f":"Roster!O22","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D23","v":0},{"$f":"Roster!E23","v":0},{"$f":"Roster!F23","v":0},{"$f":"Roster!K23","v":0},{"$f":"Roster!L23","v":0},{"$f":"Roster!M23","v":0},0,{"$f":"Roster!O23","v":0},0,null,98500,9900]
[null,null,{"$f":"Roster!D24","v":0},{"$f":"Roster!E24","v":0},{"$f":"Roster!F24","v":0},{"$f":"Roster!K24","v":0},{"$f":"Roster!L24","v":0},{"$f":"Roster!M24","v":0},0,{"$f":"Roster!O24","v":0},0,null,143900,14400]
[null,null,{"$f":"Roster!D25","v":0},{"$f":"Roster!E25","v":0},{"$f":"Roster!F25","v":0},{"$f":"Roster!K25","v":0},{"$f":"Roster!L25","v":0},{"$f":"Roster!M25","v":0},0,{"$f":"Roster!O25","v":0},0,null,103600,10400]
[null,null,{"$f":"Roster!D26","v":0},{"$f":"Roster!E26","v":0},{"$f":"Roster!F26","v":0},{"$f":"Roster!K26","v":0},{"$f":"Roster!L26","v":0},{"$f":"Roster!M26","v":0},0,{"$f":"Roster!O26","v":0},0]
[null,null,{"$f":"Roster!D27","v":0},{"$f":"Roster!E27","v":0},{"$f":"Roster!F27","v":0},{"$f":"Roster!K27","v":0},{"$f":"Roster!L27","v":0},{"$f":"Roster!M27","v":0},0,{"$f":"Roster!O27","v":0},0]
[null,null,{"$f":"Roster!D28","v":0},{"$f":"Roster!E28","v":0},{"$f":"Roster!F28","v":0},{"$f":"Roster!K28","v":0},{"$f":"Roster!L28","v":0},{"$f":"Roster!M28","v":0},0,{"$f":"Roster!O28","v":0},0,null,193800,19400]
[null,null,{"$f":"Roster!D29","v":0},{"$f":"Roster!E29","v":0},{"$f":"Roster!F29","v":0},{"$f":"Roster!K29","v":0},{"$f":"Roster!L29","v":0},{"$f":"Roster!M29","v":0},0,{"$f":"Roster!O29","v":0},0,null,166300,16600]
[null,null,{"$f":"Roster!D30","v":0},{"$f":"Roster!E30","v":0},{"$f":"Roster!F30","v":0},{"$f":"Roster!K30","v":0},{"$f":"Roster!L30","v":0},{"$f":"Roster!M30","v":0},0,{"$f":"Roster!O30","v":0},0,null,133900,13400]
[null,null,{"$f":"Roster!D31","v":0},{"$f":"Roster!E31","v":0},{"$f":"Roster!F31","v":0},{"$f":"Roster!K31","v":0},{"$f":"Roster!L31","v":0},{"$f":"Roster!M31","v":0},0,{"$f":"Roster!O31","v":0},0,null,108900,10900]
[null,null,{"$f":"Roster!D32","v":0},{"$f":"Roster!E32","v":0},{"$f":"Roster!F32","v":0},{"$f":"Roster!K32","v":0},{"$f":"Roster!L32","v":0},{"$f":"Roster!M32","v":0},0,{"$f":"Roster!O32","v":0},0,null,108900,10900]
[null,null,{"$f":"Roster!D33","v":0},{"$f":"Roster!E33","v":0},{"$f":"Roster!F33","v":0},{"$f":"Roster!K33","v":0},{"$f":"Roster!L33","v":0},{"$f":"Roster!M33","v":0},0,{"$f":"Roster!O33","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D34","v":0},{"$f":"Roster!E34","v":0},{"$f":"Roster!F34","v":0},{"$f":"Roster!K34","v":0},{"$f":"Roster!L34","v":0},{"$f":"Roster!M34","v":0},0,{"$f":"Roster!O34","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D35","v":0},{"$f":"Roster!E35","v":0},{"$f":"Roster!F35","v":0},{"$f":"Roster!K35","v":0},{"$f":"Roster!L35","v":0},{"$f":"Roster!M35","v":0},0,{"$f":"Roster!O35","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D36","v":0},{"$f":"Roster!E36","v":0},{"$f":"Roster!F36","v":0},{"$f":"Roster!K36","v":0},{"$f":"Roster!L36","v":0},{"$f":"Roster!M36","v":0},0,{"$f":"Roster!O36","v":0},0,null,108900,10900]
[null,null,{"$f":"Roster!D37","v":0},{"$f":"Roster!E37","v":0},{"$f":"Roster!F37","v":0},{"$f":"Roster!K37","v":0},{"$f":"Roster!L37","v":0},{"$f":"Roster!M37","v":0},0,{"$f":"Roster!O37","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D38","v":0},{"$f":"Roster!E38","v":0},{"$f":"Roster!F38","v":0},{"$f":"Roster!K38","v":0},{"$f":"Roster!L38","v":0},{"$f":"Roster!M38","v":0},0,{"$f":"Roster!O38","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D39","v":0},{"$f":"Roster!E39","v":0},{"$f":"Roster!F39","v":0},{"$f":"Roster!K39","v":0},{"$f":"Roster!L39","v":0},{"$f":"Roster!M39","v":0},0,{"$f":"Roster!O39","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D40","v":0},{"$f":"Roster!E40","v":0},{"$f":"Roster!F40","v":0},{"$f":"Roster!K40","v":0},{"$f":"Roster!L40","v":0},{"$f":"Roster!M40","v":0},0,{"$f":"Roster!O40","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D41","v":0},{"$f":"Roster!E41","v":0},{"$f":"Roster!F41","v":0},{"$f":"Roster!K41","v":0},{"$f":"Roster!L41","v":0},{"$f":"Roster!M41","v":0},0,{"$f":"Roster!O41","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D42","v":0},{"$f":"Roster!E42","v":0},{"$f":"Roster!F42","v":0},{"$f":"Roster!K42","v":0},{"$f":"Roster!L42","v":0},{"$f":"Roster!M42","v":0},0,{"$f":"Roster!O42","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D43","v":0},{"$f":"Roster!E43","v":0},{"$f":"Roster!F43","v":0},{"$f":"Roster!K43","v":0},{"$f":"Roster!L43","v":0},{"$f":"Roster!M43","v":0},0,{"$f":"Roster!O43","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D44","v":0},{"$f":"Roster!E44","v":0},{"$f":"Roster!F44","v":0},{"$f":"Roster!K44","v":0},{"$f":"Roster!L44","v":0},{"$f":"Roster!M44","v":0},0,{"$f":"Roster!O44","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D45","v":0},{"$f":"Roster!E45","v":0},{"$f":"Roster!F45","v":0},{"$f":"Roster!K45","v":0},{"$f":"Roster!L45","v":0},{"$f":"Roster!M45","v":0},0,{"$f":"Roster!O45","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D46","v":0},{"$f":"Roster!E46","v":0},{"$f":"Roster!F46","v":0},{"$f":"Roster!K46","v":0},{"$f":"Roster!L46","v":0},{"$f":"Roster!M46","v":0},0,{"$f":"Roster!O46","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D47","v":0},{"$f":"Roster!E47","v":0},{"$f":"Roster!F47","v":0},{"$f":"Roster!K47","v":0},{"$f":"Roster!L47","v":0},{"$f":"Roster!M47","v":0},0,{"$f":"Roster!O47","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D48","v":0},{"$f":"Roster!E48","v":0},{"$f":"Roster!F48","v":0},{"$f":"Roster!K48","v":0},{"$f":"Roster!L48","v":0},{"$f":"Roster!M48","v":0},0,{"$f":"Roster!O48","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D49","v":0},{"$f":"Roster!E49","v":0},{"$f":"Roster!F49","v":0},{"$f":"Roster!K49","v":0},{"$f":"Roster!L49","v":0},{"$f":"Roster!M49","v":0},0,{"$f":"Roster!O49","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D50","v":0},{"$f":"Roster!E50","v":0},{"$f":"Roster!F50","v":0},{"$f":"Roster!K50","v":0},{"$f":"Roster!L50","v":0},{"$f":"Roster!M50","v":0},0,{"$f":"Roster!O50","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D51","v":0},{"$f":"Roster!E51","v":0},{"$f":"Roster!F51","v":0},{"$f":"Roster!K51","v":0},{"$f":"Roster!L51","v":0},{"$f":"Roster!M51","v":0},0,{"$f":"Roster!O51","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D52","v":0},{"$f":"Roster!E52","v":0},{"$f":"Roster!F52","v":0},{"$f":"Roster!K52","v":0},{"$f":"Roster!L52","v":0},{"$f":"Roster!M52","v":0},0,{"$f":"Roster!O52","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D53","v":0},{"$f":"Roster!E53","v":0},{"$f":"Roster!F53","v":0},{"$f":"Roster!K53","v":0},{"$f":"Roster!L53","v":0},{"$f":"Roster!M53","v":0},0,{"$f":"Roster!O53","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D54","v":0},{"$f":"Roster!E54","v":0},{"$f":"Roster!F54","v":0},{"$f":"Roster!K54","v":0},{"$f":"Roster!L54","v":0},{"$f":"Roster!M54","v":0},0,{"$f":"Roster!O54","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D55","v":0},{"$f":"Roster!E55","v":0},{"$f":"Roster!F55","v":0},{"$f":"Roster!K55","v":0},{"$f":"Roster!L55","v":0},{"$f":"Roster!M55","v":0},0,{"$f":"Roster!O55","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D56","v":0},{"$f":"Roster!E56","v":0},{"$f":"Roster!F56","v":0},{"$f":"Roster!K56","v":0},{"$f":"Roster!L56","v":0},{"$f":"Roster!M56","v":0},0,{"$f":"Roster!O56","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D57","v":0},{"$f":"Roster!E57","v":0},{"$f":"Roster!F57","v":0},{"$f":"Roster!K57","v":0},{"$f":"Roster!L57","v":0},{"$f":"Roster!M57","v":0},0,{"$f":"Roster!O57","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D58","v":0},{"$f":"Roster!E58","v":0},{"$f":"Roster!F58","v":0},{"$f":"Roster!K58","v":0},{"$f":"Roster!L58","v":0},{"$f":"Roster!M58","v":0},0,{"$f":"Roster!O58","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D59","v":0},{"$f":"Roster!E59","v":0},{"$f":"Roster!F59","v":0},{"$f":"Roster!K59","v":0},{"$f":"Roster!L59","v":0},{"$f":"Roster!M59","v":0},0,{"$f":"Roster!O59","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D60","v":0},{"$f":"Roster!E60","v":0},{"$f":"Roster!F60","v":0},{"$f":"Roster!K60","v":0},{"$f":"Roster!L60","v":0},{"$f":"Roster!M60","v":0},0,{"$f":"Roster!O60","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D61","v":0},{"$f":"Roster!E61","v":0},{"$f":"Roster!F61","v":0},{"$f":"Roster!K61","v":0},{"$f":"Roster!L61","v":0},{"$f":"Roster!M61","v":0},0,{"$f":"Roster!O61","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D62","v":0},{"$f":"Roster!E62","v":0},{"$f":"Roster!F62","v":0},{"$f":"Roster!K62","v":0},{"$f":"Roster!L62","v":0},{"$f":"Roster!M62","v":0},0,{"$f":"Roster!O62","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D63","v":0},{"$f":"Roster!E63","v":0},{"$f":"Roster!F63","v":0},{"$f":"Roster!K63","v":0},{"$f":"Roster!L63","v":0},{"$f":"Roster!M63","v":0},0,{"$f":"Roster!O63","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D64","v":0},{"$f":"Roster!E64","v":0},{"$f":"Roster!F64","v":0},{"$f":"Roster!K64","v":0},{"$f":"Roster!L64","v":0},{"$f":"Roster!M64","v":0},0,{"$f":"Roster!O64","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D65","v":0},{"$f":"Roster!E65","v":0},{"$f":"Roster!F65","v":0},{"$f":"Roster!K65","v":0},{"$f":"Roster!L65","v":0},{"$f":"Roster!M65","v":0},0,{"$f":"Roster!O65","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D66","v":0},{"$f":"Roster!E66","v":0},{"$f":"Roster!F66","v":0},{"$f":"Roster!K66","v":0},{"$f":"Roster!L66","v":0},{"$f":"Roster!M66","v":0},0,{"$f":"Roster!O66","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D67","v":0},{"$f":"Roster!E67","v":0},{"$f":"Roster!F67","v":0},{"$f":"Roster!K67","v":0},{"$f":"Roster!L67","v":0},{"$f":"Roster!M67","v":0},0,{"$f":"Roster!O67","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D68","v":0},{"$f":"Roster!E68","v":0},{"$f":"Roster!F68","v":0},{"$f":"Roster!K68","v":0},{"$f":"Roster!L68","v":0},{"$f":"Roster!M68","v":0},0,{"$f":"Roster!O68","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D69","v":0},{"$f":"Roster!E69","v":0},{"$f":"Roster!F69","v":0},{"$f":"Roster!K69","v":0},{"$f":"Roster!L69","v":0},{"$f":"Roster!M69","v":0},0,{"$f":"Roster!O69","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D70","v":0},{"$f":"Roster!E70","v":0},{"$f":"Roster!F70","v":0},{"$f":"Roster!K70","v":0},{"$f":"Roster!L70","v":0},{"$f":"Roster!M70","v":0},0,{"$f":"Roster!O70","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D71","v":0},{"$f":"Roster!E71","v":0},{"$f":"Roster!F71","v":0},{"$f":"Roster!K71","v":0},{"$f":"Roster!L71","v":0},{"$f":"Roster!M71","v":0},0,{"$f":"Roster!O71","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D72","v":0},{"$f":"Roster!E72","v":0},{"$f":"Roster!F72","v":0},{"$f":"Roster!K72","v":0},{"$f":"Roster!L72","v":0},{"$f":"Roster!M72","v":0},0,{"$f":"Roster!O72","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D73","v":0},{"$f":"Roster!E73","v":0},{"$f":"Roster!F73","v":0},{"$f":"Roster!K73","v":0},{"$f":"Roster!L73","v":0},{"$f":"Roster!M73","v":0},0,{"$f":"Roster!O73","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D74","v":0},{"$f":"Roster!E74","v":0},{"$f":"Roster!F74","v":0},{"$f":"Roster!K74","v":0},{"$f":"Roster!L74","v":0},{"$f":"Roster!M74","v":0},0,{"$f":"Roster!O74","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D75","v":0},{"$f":"Roster!E75","v":0},{"$f":"Roster!F75","v":0},{"$f":"Roster!K75","v":0},{"$f":"Roster!L75","v":0},{"$f":"Roster!M75","v":0},{"$f":"F101+G101+H101","v":0},{"$f":"Roster!O75","v":0},{"$f":"I101+J101","v":0},null,88300,8800]
[null,null,{"$f":"Roster!D76","v":0},{"$f":"Roster!E76","v":0},{"$f":"Roster!F76","v":0},{"$f":"Roster!K76","v":0},{"$f":"Roster!L76","v":0},{"$f":"Roster!M76","v":0},0,{"$f":"Roster!O76","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D77","v":0},{"$f":"Roster!E77","v":0},{"$f":"Roster!F77","v":0},{"$f":"Roster!K77","v":0},{"$f":"Roster!L77","v":0},{"$f":"Roster!M77","v":0},0,{"$f":"Roster!O77","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D78","v":0},{"$f":"Roster!E78","v":0},{"$f":"Roster!F78","v":0},{"$f":"Roster!K78","v":0},{"$f":"Roster!L78","v":0},{"$f":"Roster!M78","v":0},0,{"$f":"Roster!O78","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D79","v":0},{"$f":"Roster!E79","v":0},{"$f":"Roster!F79","v":0},{"$f":"Roster!K79","v":0},{"$f":"Roster!L79","v":0},{"$f":"Roster!M79","v":0},0,{"$f":"Roster!O79","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D80","v":0},{"$f":"Roster!E80","v":0},{"$f":"Roster!F80","v":0},{"$f":"Roster!K80","v":0},{"$f":"Roster!L80","v":0},{"$f":"Roster!M80","v":0},0,{"$f":"Roster!O80","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D81","v":0},{"$f":"Roster!E81","v":0},{"$f":"Roster!F81","v":0},{"$f":"Roster!K81","v":0},{"$f":"Roster!L81","v":0},{"$f":"Roster!M81","v":0},0,{"$f":"Roster!O81","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D82","v":0},{"$f":"Roster!E82","v":0},{"$f":"Roster!F82","v":0},{"$f":"Roster!K82","v":0},{"$f":"Roster!L82","v":0},{"$f":"Roster!M82","v":0},0,{"$f":"Roster!O82","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D83","v":0},{"$f":"Roster!E83","v":0},{"$f":"Roster!F83","v":0},{"$f":"Roster!K83","v":0},{"$f":"Roster!L83","v":0},{"$f":"Roster!M83","v":0},0,{"$f":"Roster!O83","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D84","v":0},{"$f":"Roster!E84","v":0},{"$f":"Roster!F84","v":0},{"$f":"Roster!K84","v":0},{"$f":"Roster!L84","v":0},{"$f":"Roster!M84","v":0},0,{"$f":"Roster!O84","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D85","v":0},{"$f":"Roster!E85","v":0},{"$f":"Roster!F85","v":0},{"$f":"Roster!K85","v":0},{"$f":"Roster!L85","v":0},{"$f":"Roster!M85","v":0},0,{"$f":"Roster!O85","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D86","v":0},{"$f":"Roster!E86","v":0},{"$f":"Roster!F86","v":0},{"$f":"Roster!K86","v":0},{"$f":"Roster!L86","v":0},{"$f":"Roster!M86","v":0},0,{"$f":"Roster!O86","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D87","v":0},{"$f":"Roster!E87","v":0},{"$f":"Roster!F87","v":0},{"$f":"Roster!K87","v":0},{"$f":"Roster!L87","v":0},{"$f":"Roster!M87","v":0},0,{"$f":"Roster!O87","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D88","v":0},{"$f":"Roster!E88","v":0},{"$f":"Roster!F88","v":0},{"$f":"Roster!K88","v":0},{"$f":"Roster!L88","v":0},{"$f":"Roster!M88","v":0},0,{"$f":"Roster!O88","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D89","v":0},{"$f":"Roster!E89","v":0},{"$f":"Roster!F89","v":0},{"$f":"Roster!K89","v":0},{"$f":"Roster!L89","v":0},{"$f":"Roster!M89","v":0},0,{"$f":"Roster!O89","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D90","v":0},{"$f":"Roster!E90","v":0},{"$f":"Roster!F90","v":0},{"$f":"Roster!K90","v":0},{"$f":"Roster!L90","v":0},{"$f":"Roster!M90","v":0},0,{"$f":"Roster!O90","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D91","v":0},{"$f":"Roster!E91","v":0},{"$f":"Roster!F91","v":0},{"$f":"Roster!K91","v":0},{"$f":"Roster!L91","v":0},{"$f":"Roster!M91","v":0},0,{"$f":"Roster!O91","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D92","v":0},{"$f":"Roster!E92","v":0},{"$f":"Roster!F92","v":0},{"$f":"Roster!K92","v":0},{"$f":"Roster!L92","v":0},{"$f":"Roster!M92","v":0},0,{"$f":"Roster!O92","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D93","v":0},{"$f":"Roster!E93","v":0},{"$f":"Roster!F93","v":0},{"$f":"Roster!K93","v":0},{"$f":"Roster!L93","v":0},{"$f":"Roster!M93","v":0},0,{"$f":"Roster!O93","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D94","v":0},{"$f":"Roster!E94","v":0},{"$f":"Roster!F94","v":0},{"$f":"Roster!K94","v":0},{"$f":"Roster!L94","v":0},{"$f":"Roster!M94","v":0},0,{"$f":"Roster!O94","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D95","v":0},{"$f":"Roster!E95","v":0},{"$f":"Roster!F95","v":0},{"$f":"Roster!K95","v":0},{"$f":"Roster!L95","v":0},{"$f":"Roster!M95","v":0},0,{"$f":"Roster!O95","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D96","v":0},{"$f":"Roster!E96","v":0},{"$f":"Roster!F96","v":0},{"$f":"Roster!K96","v":0},{"$f":"Roster!L96","v":0},{"$f":"Roster!M96","v":0},0,{"$f":"Roster!O96","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D97","v":0},{"$f":"Roster!E97","v":0},{"$f":"Roster!F97","v":0},{"$f":"Roster!K97","v":0},{"$f":"Roster!L97","v":0},{"$f":"Roster!M97","v":0},0,{"$f":"Roster!O97","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D98","v":0},{"$f":"Roster!E98","v":0},{"$f":"Roster!F98","v":0},{"$f":"Roster!K98","v":0},{"$f":"Roster!L98","v":0},{"$f":"Roster!M98","v":0},0,{"$f":"Roster!O98","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D99","v":0},{"$f":"Roster!E99","v":0},{"$f":"Roster!F99","v":0},{"$f":"Roster!K99","v":0},{"$f":"Roster!L99","v":0},{"$f":"Roster!M99","v":0},0,{"$f":"Roster!O99","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D100","v":0},{"$f":"Roster!E100","v":0},{"$f":"Roster!F100","v":0},{"$f":"Roster!K100","v":0},{"$f":"Roster!L100","v":0},{"$f":"Roster!M100","v":0},0,{"$f":"Roster!O100","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D101","v":0},{"$f":"Roster!E101","v":0},{"$f":"Roster!F101","v":0},{"$f":"Roster!K101","v":0},{"$f":"Roster!L101","v":0},{"$f":"Roster!M101","v":0},0,{"$f":"Roster!O101","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D102","v":0},{"$f":"Roster!E102","v":0},{"$f":"Roster!F102","v":0},{"$f":"Roster!K102","v":0},{"$f":"Roster!L102","v":0},{"$f":"Roster!M102","v":0},0,{"$f":"Roster!O102","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D103","v":0},{"$f":"Roster!E103","v":0},{"$f":"Roster!F103","v":0},{"$f":"Roster!K103","v":0},{"$f":"Roster!L103","v":0},{"$f":"Roster!M103","v":0},0,{"$f":"Roster!O103","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D104","v":0},{"$f":"Roster!E104","v":0},{"$f":"Roster!F104","v":0},{"$f":"Roster!K104","v":0},{"$f":"Roster!L104","v":0},{"$f":"Roster!M104","v":0},0,{"$f":"Roster!O104","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D105","v":0},{"$f":"Roster!E105","v":0},{"$f":"Roster!F105","v":0},{"$f":"Roster!K105","v":0},{"$f":"Roster!L105","v":0},{"$f":"Roster!M105","v":0},0,{"$f":"Roster!O105","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D106","v":0},{"$f":"Roster!E106","v":0},{"$f":"Roster!F106","v":0},{"$f":"Roster!K106","v":0},{"$f":"Roster!L106","v":0},{"$f":"Roster!M106","v":0},0,{"$f":"Roster!O106","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D107","v":0},{"$f":"Roster!E107","v":0},{"$f":"Roster!F107","v":0},{"$f":"Roster!K107","v":0},{"$f":"Roster!L107","v":0},{"$f":"Roster!M107","v":0},0,{"$f":"Roster!O107","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D108","v":0},{"$f":"Roster!E108","v":0},{"$f":"Roster!F108","v":0},{"$f":"Roster!K108","v":0},{"$f":"Roster!L108","v":0},{"$f":"Roster!M108","v":0},0,{"$f":"Roster!O108","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D109","v":0},{"$f":"Roster!E109","v":0},{"$f":"Roster!F109","v":0},{"$f":"Roster!K109","v":0},{"$f":"Roster!L109","v":0},{"$f":"Roster!M109","v":0},0,{"$f":"Roster!O109","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D110","v":0},{"$f":"Roster!E110","v":0},{"$f":"Roster!F110","v":0},{"$f":"Roster!K110","v":0},{"$f":"Roster!L110","v":0},{"$f":"Roster!M110","v":0},0,{"$f":"Roster!O110","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D111","v":0},{"$f":"Roster!E111","v":0},{"$f":"Roster!F111","v":0},{"$f":"Roster!K111","v":0},{"$f":"Roster!L111","v":0},{"$f":"Roster!M111","v":0},0,{"$f":"Roster!O111","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D112","v":0},{"$f":"Roster!E112","v":0},{"$f":"Roster!F112","v":0},{"$f":"Roster!K112","v":0},{"$f":"Roster!L112","v":0},{"$f":"Roster!M112","v":0},0,{"$f":"Roster!O112","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D113","v":0},{"$f":"Roster!E113","v":0},{"$f":"Roster!F113","v":0},{"$f":"Roster!K113","v":0},{"$f":"Roster!L113","v":0},{"$f":"Roster!M113","v":0},0,{"$f":"Roster!O113","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D114","v":0},{"$f":"Roster!E114","v":0},{"$f":"Roster!F114","v":0},{"$f":"Roster!K114","v":0},{"$f":"Roster!L114","v":0},{"$f":"Roster!M114","v":0},0,{"$f":"Roster!O114","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D115","v":0},{"$f":"Roster!E115","v":0},{"$f":"Roster!F115","v":0},{"$f":"Roster!K115","v":0},{"$f":"Roster!L115","v":0},{"$f":"Roster!M115","v":0},0,{"$f":"Roster!O115","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D116","v":0},{"$f":"Roster!E116","v":0},{"$f":"Roster!F116","v":0},{"$f":"Roster!K116","v":0},{"$f":"Roster!L116","v":0},{"$f":"Roster!M116","v":0},0,{"$f":"Roster!O116","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D117","v":0},{"$f":"Roster!E117","v":0},{"$f":"Roster!F117","v":0},{"$f":"Roster!K117","v":0},{"$f":"Roster!L117","v":0},{"$f":"Roster!M117","v":0},0,{"$f":"Roster!O117","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D118","v":0},{"$f":"Roster!E118","v":0},{"$f":"Roster!F118","v":0},{"$f":"Roster!K118","v":0},{"$f":"Roster!L118","v":0},{"$f":"Roster!M118","v":0},0,{"$f":"Roster!O118","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D119","v":0},{"$f":"Roster!E119","v":0},{"$f":"Roster!F119","v":0},{"$f":"Roster!K119","v":0},{"$f":"Roster!L119","v":0},{"$f":"Roster!M119","v":0},0,{"$f":"Roster!O119","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D120","v":0},{"$f":"Roster!E120","v":0},{"$f":"Roster!F120","v":0},{"$f":"Roster!K120","v":0},{"$f":"Roster!L120","v":0},{"$f":"Roster!M120","v":0},0,{"$f":"Roster!O120","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D121","v":0},{"$f":"Roster!E121","v":0},{"$f":"Roster!F121","v":0},{"$f":"Roster!K121","v":0},{"$f":"Roster!L121","v":0},{"$f":"Roster!M121","v":0},0,{"$f":"Roster!O121","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D122","v":0},{"$f":"Roster!E122","v":0},{"$f":"Roster!F122","v":0},{"$f":"Roster!K122","v":0},{"$f":"Roster!L122","v":0},{"$f":"Roster!M122","v":0},0,{"$f":"Roster!O122","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D123","v":0},{"$f":"Roster!E123","v":0},{"$f":"Roster!F123","v":0},{"$f":"Roster!K123","v":0},{"$f":"Roster!L123","v":0},{"$f":"Roster!M123","v":0},0,{"$f":"Roster!O123","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D124","v":0},{"$f":"Roster!E124","v":0},{"$f":"Roster!F124","v":0},{"$f":"Roster!K124","v":0},{"$f":"Roster!L124","v":0},{"$f":"Roster!M124","v":0},0,{"$f":"Roster!O124","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D125","v":0},{"$f":"Roster!E125","v":0},{"$f":"Roster!F125","v":0},{"$f":"Roster!K125","v":0},{"$f":"Roster!L125","v":0},{"$f":"Roster!M125","v":0},0,{"$f":"Roster!O125","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D126","v":0},{"$f":"Roster!E126","v":0},{"$f":"Roster!F126","v":0},{"$f":"Roster!K126","v":0},{"$f":"Roster!L126","v":0},{"$f":"Roster!M126","v":0},0,{"$f":"Roster!O126","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D127","v":0},{"$f":"Roster!E127","v":0},{"$f":"Roster!F127","v":0},{"$f":"Roster!K127","v":0},{"$f":"Roster!L127","v":0},{"$f":"Roster!M127","v":0},0,{"$f":"Roster!O127","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D128","v":0},{"$f":"Roster!E128","v":0},{"$f":"Roster!F128","v":0},{"$f":"Roster!K128","v":0},{"$f":"Roster!L128","v":0},{"$f":"Roster!M128","v":0},0,{"$f":"Roster!O128","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D129","v":0},{"$f":"Roster!E129","v":0},{"$f":"Roster!F129","v":0},{"$f":"Roster!K129","v":0},{"$f":"Roster!L129","v":0},{"$f":"Roster!M129","v":0},0,{"$f":"Roster!O129","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D130","v":0},{"$f":"Roster!E130","v":0},{"$f":"Roster!F130","v":0},{"$f":"Roster!K130","v":0},{"$f":"Roster!L130","v":0},{"$f":"Roster!M130","v":0},0,{"$f":"Roster!O130","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D131","v":0},{"$f":"Roster!E131","v":0},{"$f":"Roster!F131","v":0},{"$f":"Roster!K131","v":0},{"$f":"Roster!L131","v":0},{"$f":"Roster!M131","v":0},0,{"$f":"Roster!O131","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D132","v":0},{"$f":"Roster!E132","v":0},{"$f":"Roster!F132","v":0},{"$f":"Roster!K132","v":0},{"$f":"Roster!L132","v":0},{"$f":"Roster!M132","v":0},0,{"$f":"Roster!O132","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D133","v":0},{"$f":"Roster!E133","v":0},{"$f":"Roster!F133","v":0},{"$f":"Roster!K133","v":0},{"$f":"Roster!L133","v":0},{"$f":"Roster!M133","v":0},0,{"$f":"Roster!O133","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D134","v":0},{"$f":"Roster!E134","v":0},{"$f":"Roster!F134","v":0},{"$f":"Roster!K134","v":0},{"$f":"Roster!L134","v":0},{"$f":"Roster!M134","v":0},0,{"$f":"Roster!O134","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D135","v":0},{"$f":"Roster!E135","v":0},{"$f":"Roster!F135","v":0},{"$f":"Roster!K135","v":0},{"$f":"Roster!L135","v":0},{"$f":"Roster!M135","v":0},0,{"$f":"Roster!O135","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D136","v":0},{"$f":"Roster!E136","v":0},{"$f":"Roster!F136","v":0},{"$f":"Roster!K136","v":0},{"$f":"Roster!L136","v":0},{"$f":"Roster!M136","v":0},0,{"$f":"Roster!O136","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D137","v":0},{"$f":"Roster!E137","v":0},{"$f":"Roster!F137","v":0},{"$f":"Roster!K137","v":0},{"$f":"Roster!L137","v":0},{"$f":"Roster!M137","v":0},0,{"$f":"Roster!O137","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D138","v":0},{"$f":"Roster!E138","v":0},{"$f":"Roster!F138","v":0},{"$f":"Roster!K138","v":0},{"$f":"Roster!L138","v":0},{"$f":"Roster!M138","v":0},0,{"$f":"Roster!O138","v":0},0,null,88300,8800]
[null,null,{"$f":"Roster!D139","v":0},{"$f":"Roster!E139","v":0},{"$f":"Roster!F139","v":0},{"$f":"Roster!K139","v":0},{"$f":"Roster!L139","v":0},{"$f":"Roster!M139","v":0},{"$f":"F165+G165+H165","v":0},{"$f":"Roster!O139","v":0},{"$f":"I165+J165","v":0},null,88300,8800]
[]
[null,null,"APPROVALS:"]
[]
[null,null,"AVC/DBO",null,null,null,null,null,"Date"]
[]
[null,null,"Department Chair",null,null,null,null,null,"Date"]
[]
[null,null,"VCHS/Dean",null,null,null,null,null,"Date"]
[]
[null,null,"Other",null,null,null,null,null,"Date"]
[]
[]
[null,null,"This form is routed to Han Ho (h3ho@health.ucsd.edu) or ARCrequest@health.ucsd.edu prior to submission to the Dean."]

{"sheet":"checklist","index":1,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Checklist to review before sending for Dean's or VC's approval:"]
[]
[]
["APU profile form:"]
[null,"add all Faculty that belong to the code (including all the new Faculty appointments started during the current/prior FY)"]
[null,"remove all Faculty that no longer belong to the code"]
[null,"make sure all salary are based on the current, approved rank, step, and HSCP salary scales (do not use projected info)"]
[null,"* if APU scale is being changed for the APU code -> calculate the X', offscale, and Y based on the changed APU scale for ALL Faculty being listed"]
[null,"* if Faculty is being added to the APU code  -> calculate the X', offscale, and Y based on the changed APU scale for the newly added Faculty only"]
[null,"review to see if any APU code has fewer than 5 members, if so, this will be a compliance issue and department will need to provide justification in the memo to ask for the exceptional approval "]
[]
[]
["Chair's memo needs to include the following info:"]
[null,"list of all the changes being requested"]
[null,"justification for the requested changes"]
[null,"confirmation that all APU members are in good standing"]
[null,"confirmation that the department accepts 415(m) liability that may result"]
[null,"confirmation that the APU will be able to maintain the covered compensation rate for at least 3 years"]
[null,"if any APU code has fewer than 5 members, need to provide justification in the memo to ask for the exceptional approval "]

{"sheet":"Roster","index":2,"n_rows":139,"n_cols":16,"rows_kept":139,"cut":false,"hidden":false,"merged":[[7,10,7,14],[7,0,7,1],[7,2,7,9]]}
["I N S T R U C T I O N S :"]
["1. Click the",null,"button on the Roster tab, to clear existing data and prepare the form for entry.",null,null,null,null,null,"6. Paste Values (V) into the section highlighted yellow below (starting in Cell C10)."]
["2. In ARC ServiceNow, go to ARC Report Library > Compensation Reports > APU Profile Form.",null,null,null,null,null,null,null,"7. Type in the APU Code in Cell A10 and the APU Scale in Cell B10 (highlighted orange)."]
["3. In the APU Name Search box, type in the desired APU Code and hit Enter.",null,null,null,null,null,null,null,"7. Delete employees moving out of the APU and add employees moving into the APU."]
["4. Right click anywhere in the headers, go to the Export menu and select Excel (.xlsx).",null,null,null,null,null,null,null,"8. Sort Column D (AIR Profile) A to Z, so faculty members appear in alphabetical order."]
["5. Copy all data from the exported spreadsheet in Column C through Column J, starting at Row 2.",null,null,null,null,null,null,null,"10. On the APU Profile Form, hide all the blank linges and highlight the rows with new faculty."]
[]
["MANUAL  -  MANUAL",null,"A I R E L    -    A I R E L    -    A I R E L    -    A I R E L    -    A I R E L    -    A I R E L    -    A I R E L    -   A I R E L    -    A I R E L",null,null,null,null,null,null,null,"CALCULATED   -   CALCULATED   -   CALCULATED   -   CALCULATED"]
["APU Code","APU Scale","Department","AIR Profile","Rank","Step","Base (X)","Off Scale X","Total Negotiated (100%)","Stipend","Base (X)","X'","Total Off-Scale (X+X')","Total Covered Comp","Y","RankStepScale"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P10,'FY24-FY25 Scales'!A:J,10,FALSE),G10)","v":0},{"$f":"IFERROR(VLOOKUP(P10,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G10*VLOOKUP(B10*1,'APU Scale'!A:B,2,FALSE)-G10,-2))","v":0},{"$f":"ROUND(H10*VLOOKUP(B10*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},{"$f":"K10+L10+M10","v":0},{"$f":"IF(I10-J10-N10<0,0,I10-J10-N10)","v":0},{"$f":"CONCATENATE(E10,F10,B10)","v":""}]
[{"$f":"A10","v":0},{"$f":"B10","v":0},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P11,'FY24-FY25 Scales'!A:J,10,FALSE),G11)","v":0},{"$f":"IFERROR(VLOOKUP(P11,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G11*VLOOKUP(B11*1,'APU Scale'!A:B,2,FALSE)-G11,-2))","v":0},{"$f":"ROUND(H11*VLOOKUP(B11*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P12,'FY24-FY25 Scales'!A:J,10,FALSE),G12)","v":0},{"$f":"IFERROR(VLOOKUP(P12,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G12*VLOOKUP(B12*1,'APU Scale'!A:B,2,FALSE)-G12,-2))","v":0},{"$f":"ROUND(H12*VLOOKUP(B12*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P13,'FY24-FY25 Scales'!A:J,10,FALSE),G13)","v":0},{"$f":"IFERROR(VLOOKUP(P13,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G13*VLOOKUP(B13*1,'APU Scale'!A:B,2,FALSE)-G13,-2))","v":0},{"$f":"ROUND(H13*VLOOKUP(B13*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P14,'FY24-FY25 Scales'!A:J,10,FALSE),G14)","v":0},{"$f":"IFERROR(VLOOKUP(P14,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G14*VLOOKUP(B14*1,'APU Scale'!A:B,2,FALSE)-G14,-2))","v":0},{"$f":"ROUND(H14*VLOOKUP(B14*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P15,'FY24-FY25 Scales'!A:J,10,FALSE),G15)","v":0},{"$f":"IFERROR(VLOOKUP(P15,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G15*VLOOKUP(B15*1,'APU Scale'!A:B,2,FALSE)-G15,-2))","v":0},{"$f":"ROUND(H15*VLOOKUP(B15*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P16,'FY24-FY25 Scales'!A:J,10,FALSE),G16)","v":0},{"$f":"IFERROR(VLOOKUP(P16,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G16*VLOOKUP(B16*1,'APU Scale'!A:B,2,FALSE)-G16,-2))","v":0},{"$f":"ROUND(H16*VLOOKUP(B16*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P17,'FY24-FY25 Scales'!A:J,10,FALSE),G17)","v":0},{"$f":"IFERROR(VLOOKUP(P17,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G17*VLOOKUP(B17*1,'APU Scale'!A:B,2,FALSE)-G17,-2))","v":0},{"$f":"ROUND(H17*VLOOKUP(B17*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P18,'FY24-FY25 Scales'!A:J,10,FALSE),G18)","v":0},{"$f":"IFERROR(VLOOKUP(P18,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G18*VLOOKUP(B18*1,'APU Scale'!A:B,2,FALSE)-G18,-2))","v":0},{"$f":"ROUND(H18*VLOOKUP(B18*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P19,'FY24-FY25 Scales'!A:J,10,FALSE),G19)","v":0},{"$f":"IFERROR(VLOOKUP(P19,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G19*VLOOKUP(B19*1,'APU Scale'!A:B,2,FALSE)-G19,-2))","v":0},{"$f":"ROUND(H19*VLOOKUP(B19*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P20,'FY24-FY25 Scales'!A:J,10,FALSE),G20)","v":0},{"$f":"IFERROR(VLOOKUP(P20,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G20*VLOOKUP(B20*1,'APU Scale'!A:B,2,FALSE)-G20,-2))","v":0},{"$f":"ROUND(H20*VLOOKUP(B20*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P21,'FY24-FY25 Scales'!A:J,10,FALSE),G21)","v":0},{"$f":"IFERROR(VLOOKUP(P21,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G21*VLOOKUP(B21*1,'APU Scale'!A:B,2,FALSE)-G21,-2))","v":0},{"$f":"ROUND(H21*VLOOKUP(B21*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P22,'FY24-FY25 Scales'!A:J,10,FALSE),G22)","v":0},{"$f":"IFERROR(VLOOKUP(P22,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G22*VLOOKUP(B22*1,'APU Scale'!A:B,2,FALSE)-G22,-2))","v":0},{"$f":"ROUND(H22*VLOOKUP(B22*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P23,'FY24-FY25 Scales'!A:J,10,FALSE),G23)","v":0},{"$f":"IFERROR(VLOOKUP(P23,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G23*VLOOKUP(B23*1,'APU Scale'!A:B,2,FALSE)-G23,-2))","v":0},{"$f":"ROUND(H23*VLOOKUP(B23*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P24,'FY24-FY25 Scales'!A:J,10,FALSE),G24)","v":0},{"$f":"IFERROR(VLOOKUP(P24,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G24*VLOOKUP(B24*1,'APU Scale'!A:B,2,FALSE)-G24,-2))","v":0},{"$f":"ROUND(H24*VLOOKUP(B24*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P25,'FY24-FY25 Scales'!A:J,10,FALSE),G25)","v":0},{"$f":"IFERROR(VLOOKUP(P25,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G25*VLOOKUP(B25*1,'APU Scale'!A:B,2,FALSE)-G25,-2))","v":0},{"$f":"ROUND(H25*VLOOKUP(B25*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P26,'FY24-FY25 Scales'!A:J,10,FALSE),G26)","v":0},{"$f":"IFERROR(VLOOKUP(P26,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G26*VLOOKUP(B26*1,'APU Scale'!A:B,2,FALSE)-G26,-2))","v":0},{"$f":"ROUND(H26*VLOOKUP(B26*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P27,'FY24-FY25 Scales'!A:J,10,FALSE),G27)","v":0},{"$f":"IFERROR(VLOOKUP(P27,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G27*VLOOKUP(B27*1,'APU Scale'!A:B,2,FALSE)-G27,-2))","v":0},{"$f":"ROUND(H27*VLOOKUP(B27*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P28,'FY24-FY25 Scales'!A:J,10,FALSE),G28)","v":0},{"$f":"IFERROR(VLOOKUP(P28,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G28*VLOOKUP(B28*1,'APU Scale'!A:B,2,FALSE)-G28,-2))","v":0},{"$f":"ROUND(H28*VLOOKUP(B28*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P29,'FY24-FY25 Scales'!A:J,10,FALSE),G29)","v":0},{"$f":"IFERROR(VLOOKUP(P29,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G29*VLOOKUP(B29*1,'APU Scale'!A:B,2,FALSE)-G29,-2))","v":0},{"$f":"ROUND(H29*VLOOKUP(B29*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P30,'FY24-FY25 Scales'!A:J,10,FALSE),G30)","v":0},{"$f":"IFERROR(VLOOKUP(P30,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G30*VLOOKUP(B30*1,'APU Scale'!A:B,2,FALSE)-G30,-2))","v":0},{"$f":"ROUND(H30*VLOOKUP(B30*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P31,'FY24-FY25 Scales'!A:J,10,FALSE),G31)","v":0},{"$f":"IFERROR(VLOOKUP(P31,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G31*VLOOKUP(B31*1,'APU Scale'!A:B,2,FALSE)-G31,-2))","v":0},{"$f":"ROUND(H31*VLOOKUP(B31*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P32,'FY24-FY25 Scales'!A:J,10,FALSE),G32)","v":0},{"$f":"IFERROR(VLOOKUP(P32,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G32*VLOOKUP(B32*1,'APU Scale'!A:B,2,FALSE)-G32,-2))","v":0},{"$f":"ROUND(H32*VLOOKUP(B32*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P33,'FY24-FY25 Scales'!A:J,10,FALSE),G33)","v":0},{"$f":"IFERROR(VLOOKUP(P33,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G33*VLOOKUP(B33*1,'APU Scale'!A:B,2,FALSE)-G33,-2))","v":0},{"$f":"ROUND(H33*VLOOKUP(B33*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P34,'FY24-FY25 Scales'!A:J,10,FALSE),G34)","v":0},{"$f":"IFERROR(VLOOKUP(P34,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G34*VLOOKUP(B34*1,'APU Scale'!A:B,2,FALSE)-G34,-2))","v":0},{"$f":"ROUND(H34*VLOOKUP(B34*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P35,'FY24-FY25 Scales'!A:J,10,FALSE),G35)","v":0},{"$f":"IFERROR(VLOOKUP(P35,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G35*VLOOKUP(B35*1,'APU Scale'!A:B,2,FALSE)-G35,-2))","v":0},{"$f":"ROUND(H35*VLOOKUP(B35*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P36,'FY24-FY25 Scales'!A:J,10,FALSE),G36)","v":0},{"$f":"IFERROR(VLOOKUP(P36,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G36*VLOOKUP(B36*1,'APU Scale'!A:B,2,FALSE)-G36,-2))","v":0},{"$f":"ROUND(H36*VLOOKUP(B36*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P37,'FY24-FY25 Scales'!A:J,10,FALSE),G37)","v":0},{"$f":"IFERROR(VLOOKUP(P37,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G37*VLOOKUP(B37*1,'APU Scale'!A:B,2,FALSE)-G37,-2))","v":0},{"$f":"ROUND(H37*VLOOKUP(B37*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P38,'FY24-FY25 Scales'!A:J,10,FALSE),G38)","v":0},{"$f":"IFERROR(VLOOKUP(P38,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G38*VLOOKUP(B38*1,'APU Scale'!A:B,2,FALSE)-G38,-2))","v":0},{"$f":"ROUND(H38*VLOOKUP(B38*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P39,'FY24-FY25 Scales'!A:J,10,FALSE),G39)","v":0},{"$f":"IFERROR(VLOOKUP(P39,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G39*VLOOKUP(B39*1,'APU Scale'!A:B,2,FALSE)-G39,-2))","v":0},{"$f":"ROUND(H39*VLOOKUP(B39*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P40,'FY24-FY25 Scales'!A:J,10,FALSE),G40)","v":0},{"$f":"IFERROR(VLOOKUP(P40,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G40*VLOOKUP(B40*1,'APU Scale'!A:B,2,FALSE)-G40,-2))","v":0},{"$f":"ROUND(H40*VLOOKUP(B40*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P41,'FY24-FY25 Scales'!A:J,10,FALSE),G41)","v":0},{"$f":"IFERROR(VLOOKUP(P41,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G41*VLOOKUP(B41*1,'APU Scale'!A:B,2,FALSE)-G41,-2))","v":0},{"$f":"ROUND(H41*VLOOKUP(B41*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P42,'FY24-FY25 Scales'!A:J,10,FALSE),G42)","v":0},{"$f":"IFERROR(VLOOKUP(P42,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G42*VLOOKUP(B42*1,'APU Scale'!A:B,2,FALSE)-G42,-2))","v":0},{"$f":"ROUND(H42*VLOOKUP(B42*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},{"$f":"K42+L42+M42","v":0},{"$f":"IF(I42-J42-N42<0,0,I42-J42-N42)","v":0},{"$f":"CONCATENATE(E42,F42,B42)","v":"0"}]
[{"$f":"A42","v":0},{"$f":"B42","v":0},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P43,'FY24-FY25 Scales'!A:J,10,FALSE),G43)","v":0},{"$f":"IFERROR(VLOOKUP(P43,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G43*VLOOKUP(B43*1,'APU Scale'!A:B,2,FALSE)-G43,-2))","v":0},{"$f":"ROUND(H43*VLOOKUP(B43*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P44,'FY24-FY25 Scales'!A:J,10,FALSE),G44)","v":0},{"$f":"IFERROR(VLOOKUP(P44,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G44*VLOOKUP(B44*1,'APU Scale'!A:B,2,FALSE)-G44,-2))","v":0},{"$f":"ROUND(H44*VLOOKUP(B44*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P45,'FY24-FY25 Scales'!A:J,10,FALSE),G45)","v":0},{"$f":"IFERROR(VLOOKUP(P45,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G45*VLOOKUP(B45*1,'APU Scale'!A:B,2,FALSE)-G45,-2))","v":0},{"$f":"ROUND(H45*VLOOKUP(B45*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P46,'FY24-FY25 Scales'!A:J,10,FALSE),G46)","v":0},{"$f":"IFERROR(VLOOKUP(P46,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G46*VLOOKUP(B46*1,'APU Scale'!A:B,2,FALSE)-G46,-2))","v":0},{"$f":"ROUND(H46*VLOOKUP(B46*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P47,'FY24-FY25 Scales'!A:J,10,FALSE),G47)","v":0},{"$f":"IFERROR(VLOOKUP(P47,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G47*VLOOKUP(B47*1,'APU Scale'!A:B,2,FALSE)-G47,-2))","v":0},{"$f":"ROUND(H47*VLOOKUP(B47*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P48,'FY24-FY25 Scales'!A:J,10,FALSE),G48)","v":0},{"$f":"IFERROR(VLOOKUP(P48,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G48*VLOOKUP(B48*1,'APU Scale'!A:B,2,FALSE)-G48,-2))","v":0},{"$f":"ROUND(H48*VLOOKUP(B48*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P49,'FY24-FY25 Scales'!A:J,10,FALSE),G49)","v":0},{"$f":"IFERROR(VLOOKUP(P49,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G49*VLOOKUP(B49*1,'APU Scale'!A:B,2,FALSE)-G49,-2))","v":0},{"$f":"ROUND(H49*VLOOKUP(B49*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P50,'FY24-FY25 Scales'!A:J,10,FALSE),G50)","v":0},{"$f":"IFERROR(VLOOKUP(P50,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G50*VLOOKUP(B50*1,'APU Scale'!A:B,2,FALSE)-G50,-2))","v":0},{"$f":"ROUND(H50*VLOOKUP(B50*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P51,'FY24-FY25 Scales'!A:J,10,FALSE),G51)","v":0},{"$f":"IFERROR(VLOOKUP(P51,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G51*VLOOKUP(B51*1,'APU Scale'!A:B,2,FALSE)-G51,-2))","v":0},{"$f":"ROUND(H51*VLOOKUP(B51*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P52,'FY24-FY25 Scales'!A:J,10,FALSE),G52)","v":0},{"$f":"IFERROR(VLOOKUP(P52,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G52*VLOOKUP(B52*1,'APU Scale'!A:B,2,FALSE)-G52,-2))","v":0},{"$f":"ROUND(H52*VLOOKUP(B52*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P53,'FY24-FY25 Scales'!A:J,10,FALSE),G53)","v":0},{"$f":"IFERROR(VLOOKUP(P53,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G53*VLOOKUP(B53*1,'APU Scale'!A:B,2,FALSE)-G53,-2))","v":0},{"$f":"ROUND(H53*VLOOKUP(B53*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P54,'FY24-FY25 Scales'!A:J,10,FALSE),G54)","v":0},{"$f":"IFERROR(VLOOKUP(P54,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G54*VLOOKUP(B54*1,'APU Scale'!A:B,2,FALSE)-G54,-2))","v":0},{"$f":"ROUND(H54*VLOOKUP(B54*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P55,'FY24-FY25 Scales'!A:J,10,FALSE),G55)","v":0},{"$f":"IFERROR(VLOOKUP(P55,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G55*VLOOKUP(B55*1,'APU Scale'!A:B,2,FALSE)-G55,-2))","v":0},{"$f":"ROUND(H55*VLOOKUP(B55*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P56,'FY24-FY25 Scales'!A:J,10,FALSE),G56)","v":0},{"$f":"IFERROR(VLOOKUP(P56,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G56*VLOOKUP(B56*1,'APU Scale'!A:B,2,FALSE)-G56,-2))","v":0},{"$f":"ROUND(H56*VLOOKUP(B56*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P57,'FY24-FY25 Scales'!A:J,10,FALSE),G57)","v":0},{"$f":"IFERROR(VLOOKUP(P57,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G57*VLOOKUP(B57*1,'APU Scale'!A:B,2,FALSE)-G57,-2))","v":0},{"$f":"ROUND(H57*VLOOKUP(B57*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P58,'FY24-FY25 Scales'!A:J,10,FALSE),G58)","v":0},{"$f":"IFERROR(VLOOKUP(P58,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G58*VLOOKUP(B58*1,'APU Scale'!A:B,2,FALSE)-G58,-2))","v":0},{"$f":"ROUND(H58*VLOOKUP(B58*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P59,'FY24-FY25 Scales'!A:J,10,FALSE),G59)","v":0},{"$f":"IFERROR(VLOOKUP(P59,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G59*VLOOKUP(B59*1,'APU Scale'!A:B,2,FALSE)-G59,-2))","v":0},{"$f":"ROUND(H59*VLOOKUP(B59*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P60,'FY24-FY25 Scales'!A:J,10,FALSE),G60)","v":0},{"$f":"IFERROR(VLOOKUP(P60,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G60*VLOOKUP(B60*1,'APU Scale'!A:B,2,FALSE)-G60,-2))","v":0},{"$f":"ROUND(H60*VLOOKUP(B60*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P61,'FY24-FY25 Scales'!A:J,10,FALSE),G61)","v":0},{"$f":"IFERROR(VLOOKUP(P61,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G61*VLOOKUP(B61*1,'APU Scale'!A:B,2,FALSE)-G61,-2))","v":0},{"$f":"ROUND(H61*VLOOKUP(B61*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P62,'FY24-FY25 Scales'!A:J,10,FALSE),G62)","v":0},{"$f":"IFERROR(VLOOKUP(P62,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G62*VLOOKUP(B62*1,'APU Scale'!A:B,2,FALSE)-G62,-2))","v":0},{"$f":"ROUND(H62*VLOOKUP(B62*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P63,'FY24-FY25 Scales'!A:J,10,FALSE),G63)","v":0},{"$f":"IFERROR(VLOOKUP(P63,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G63*VLOOKUP(B63*1,'APU Scale'!A:B,2,FALSE)-G63,-2))","v":0},{"$f":"ROUND(H63*VLOOKUP(B63*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P64,'FY24-FY25 Scales'!A:J,10,FALSE),G64)","v":0},{"$f":"IFERROR(VLOOKUP(P64,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G64*VLOOKUP(B64*1,'APU Scale'!A:B,2,FALSE)-G64,-2))","v":0},{"$f":"ROUND(H64*VLOOKUP(B64*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P65,'FY24-FY25 Scales'!A:J,10,FALSE),G65)","v":0},{"$f":"IFERROR(VLOOKUP(P65,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G65*VLOOKUP(B65*1,'APU Scale'!A:B,2,FALSE)-G65,-2))","v":0},{"$f":"ROUND(H65*VLOOKUP(B65*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P66,'FY24-FY25 Scales'!A:J,10,FALSE),G66)","v":0},{"$f":"IFERROR(VLOOKUP(P66,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G66*VLOOKUP(B66*1,'APU Scale'!A:B,2,FALSE)-G66,-2))","v":0},{"$f":"ROUND(H66*VLOOKUP(B66*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P67,'FY24-FY25 Scales'!A:J,10,FALSE),G67)","v":0},{"$f":"IFERROR(VLOOKUP(P67,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G67*VLOOKUP(B67*1,'APU Scale'!A:B,2,FALSE)-G67,-2))","v":0},{"$f":"ROUND(H67*VLOOKUP(B67*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P68,'FY24-FY25 Scales'!A:J,10,FALSE),G68)","v":0},{"$f":"IFERROR(VLOOKUP(P68,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G68*VLOOKUP(B68*1,'APU Scale'!A:B,2,FALSE)-G68,-2))","v":0},{"$f":"ROUND(H68*VLOOKUP(B68*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P69,'FY24-FY25 Scales'!A:J,10,FALSE),G69)","v":0},{"$f":"IFERROR(VLOOKUP(P69,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G69*VLOOKUP(B69*1,'APU Scale'!A:B,2,FALSE)-G69,-2))","v":0},{"$f":"ROUND(H69*VLOOKUP(B69*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P70,'FY24-FY25 Scales'!A:J,10,FALSE),G70)","v":0},{"$f":"IFERROR(VLOOKUP(P70,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G70*VLOOKUP(B70*1,'APU Scale'!A:B,2,FALSE)-G70,-2))","v":0},{"$f":"ROUND(H70*VLOOKUP(B70*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P71,'FY24-FY25 Scales'!A:J,10,FALSE),G71)","v":0},{"$f":"IFERROR(VLOOKUP(P71,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G71*VLOOKUP(B71*1,'APU Scale'!A:B,2,FALSE)-G71,-2))","v":0},{"$f":"ROUND(H71*VLOOKUP(B71*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P72,'FY24-FY25 Scales'!A:J,10,FALSE),G72)","v":0},{"$f":"IFERROR(VLOOKUP(P72,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G72*VLOOKUP(B72*1,'APU Scale'!A:B,2,FALSE)-G72,-2))","v":0},{"$f":"ROUND(H72*VLOOKUP(B72*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P73,'FY24-FY25 Scales'!A:J,10,FALSE),G73)","v":0},{"$f":"IFERROR(VLOOKUP(P73,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G73*VLOOKUP(B73*1,'APU Scale'!A:B,2,FALSE)-G73,-2))","v":0},{"$f":"ROUND(H73*VLOOKUP(B73*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P74,'FY24-FY25 Scales'!A:J,10,FALSE),G74)","v":0},{"$f":"IFERROR(VLOOKUP(P74,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G74*VLOOKUP(B74*1,'APU Scale'!A:B,2,FALSE)-G74,-2))","v":0},{"$f":"ROUND(H74*VLOOKUP(B74*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},{"$f":"K74+L74+M74","v":0},{"$f":"IF(I74-J74-N74<0,0,I74-J74-N74)","v":0},{"$f":"CONCATENATE(E74,F74,B74)","v":"0"}]
[{"$f":"A74","v":0},{"$f":"B74","v":0},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P75,'FY24-FY25 Scales'!A:J,10,FALSE),G75)","v":0},{"$f":"IFERROR(VLOOKUP(P75,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G75*VLOOKUP(B75*1,'APU Scale'!A:B,2,FALSE)-G75,-2))","v":0},{"$f":"ROUND(H75*VLOOKUP(B75*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P76,'FY24-FY25 Scales'!A:J,10,FALSE),G76)","v":0},{"$f":"IFERROR(VLOOKUP(P76,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G76*VLOOKUP(B76*1,'APU Scale'!A:B,2,FALSE)-G76,-2))","v":0},{"$f":"ROUND(H76*VLOOKUP(B76*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P77,'FY24-FY25 Scales'!A:J,10,FALSE),G77)","v":0},{"$f":"IFERROR(VLOOKUP(P77,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G77*VLOOKUP(B77*1,'APU Scale'!A:B,2,FALSE)-G77,-2))","v":0},{"$f":"ROUND(H77*VLOOKUP(B77*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P78,'FY24-FY25 Scales'!A:J,10,FALSE),G78)","v":0},{"$f":"IFERROR(VLOOKUP(P78,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G78*VLOOKUP(B78*1,'APU Scale'!A:B,2,FALSE)-G78,-2))","v":0},{"$f":"ROUND(H78*VLOOKUP(B78*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P79,'FY24-FY25 Scales'!A:J,10,FALSE),G79)","v":0},{"$f":"IFERROR(VLOOKUP(P79,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G79*VLOOKUP(B79*1,'APU Scale'!A:B,2,FALSE)-G79,-2))","v":0},{"$f":"ROUND(H79*VLOOKUP(B79*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P80,'FY24-FY25 Scales'!A:J,10,FALSE),G80)","v":0},{"$f":"IFERROR(VLOOKUP(P80,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G80*VLOOKUP(B80*1,'APU Scale'!A:B,2,FALSE)-G80,-2))","v":0},{"$f":"ROUND(H80*VLOOKUP(B80*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P81,'FY24-FY25 Scales'!A:J,10,FALSE),G81)","v":0},{"$f":"IFERROR(VLOOKUP(P81,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G81*VLOOKUP(B81*1,'APU Scale'!A:B,2,FALSE)-G81,-2))","v":0},{"$f":"ROUND(H81*VLOOKUP(B81*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P82,'FY24-FY25 Scales'!A:J,10,FALSE),G82)","v":0},{"$f":"IFERROR(VLOOKUP(P82,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G82*VLOOKUP(B82*1,'APU Scale'!A:B,2,FALSE)-G82,-2))","v":0},{"$f":"ROUND(H82*VLOOKUP(B82*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P83,'FY24-FY25 Scales'!A:J,10,FALSE),G83)","v":0},{"$f":"IFERROR(VLOOKUP(P83,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G83*VLOOKUP(B83*1,'APU Scale'!A:B,2,FALSE)-G83,-2))","v":0},{"$f":"ROUND(H83*VLOOKUP(B83*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P84,'FY24-FY25 Scales'!A:J,10,FALSE),G84)","v":0},{"$f":"IFERROR(VLOOKUP(P84,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G84*VLOOKUP(B84*1,'APU Scale'!A:B,2,FALSE)-G84,-2))","v":0},{"$f":"ROUND(H84*VLOOKUP(B84*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P85,'FY24-FY25 Scales'!A:J,10,FALSE),G85)","v":0},{"$f":"IFERROR(VLOOKUP(P85,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G85*VLOOKUP(B85*1,'APU Scale'!A:B,2,FALSE)-G85,-2))","v":0},{"$f":"ROUND(H85*VLOOKUP(B85*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P86,'FY24-FY25 Scales'!A:J,10,FALSE),G86)","v":0},{"$f":"IFERROR(VLOOKUP(P86,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G86*VLOOKUP(B86*1,'APU Scale'!A:B,2,FALSE)-G86,-2))","v":0},{"$f":"ROUND(H86*VLOOKUP(B86*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P87,'FY24-FY25 Scales'!A:J,10,FALSE),G87)","v":0},{"$f":"IFERROR(VLOOKUP(P87,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G87*VLOOKUP(B87*1,'APU Scale'!A:B,2,FALSE)-G87,-2))","v":0},{"$f":"ROUND(H87*VLOOKUP(B87*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P88,'FY24-FY25 Scales'!A:J,10,FALSE),G88)","v":0},{"$f":"IFERROR(VLOOKUP(P88,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G88*VLOOKUP(B88*1,'APU Scale'!A:B,2,FALSE)-G88,-2))","v":0},{"$f":"ROUND(H88*VLOOKUP(B88*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P89,'FY24-FY25 Scales'!A:J,10,FALSE),G89)","v":0},{"$f":"IFERROR(VLOOKUP(P89,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G89*VLOOKUP(B89*1,'APU Scale'!A:B,2,FALSE)-G89,-2))","v":0},{"$f":"ROUND(H89*VLOOKUP(B89*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P90,'FY24-FY25 Scales'!A:J,10,FALSE),G90)","v":0},{"$f":"IFERROR(VLOOKUP(P90,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G90*VLOOKUP(B90*1,'APU Scale'!A:B,2,FALSE)-G90,-2))","v":0},{"$f":"ROUND(H90*VLOOKUP(B90*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P91,'FY24-FY25 Scales'!A:J,10,FALSE),G91)","v":0},{"$f":"IFERROR(VLOOKUP(P91,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G91*VLOOKUP(B91*1,'APU Scale'!A:B,2,FALSE)-G91,-2))","v":0},{"$f":"ROUND(H91*VLOOKUP(B91*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P92,'FY24-FY25 Scales'!A:J,10,FALSE),G92)","v":0},{"$f":"IFERROR(VLOOKUP(P92,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G92*VLOOKUP(B92*1,'APU Scale'!A:B,2,FALSE)-G92,-2))","v":0},{"$f":"ROUND(H92*VLOOKUP(B92*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P93,'FY24-FY25 Scales'!A:J,10,FALSE),G93)","v":0},{"$f":"IFERROR(VLOOKUP(P93,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G93*VLOOKUP(B93*1,'APU Scale'!A:B,2,FALSE)-G93,-2))","v":0},{"$f":"ROUND(H93*VLOOKUP(B93*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P94,'FY24-FY25 Scales'!A:J,10,FALSE),G94)","v":0},{"$f":"IFERROR(VLOOKUP(P94,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G94*VLOOKUP(B94*1,'APU Scale'!A:B,2,FALSE)-G94,-2))","v":0},{"$f":"ROUND(H94*VLOOKUP(B94*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P95,'FY24-FY25 Scales'!A:J,10,FALSE),G95)","v":0},{"$f":"IFERROR(VLOOKUP(P95,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G95*VLOOKUP(B95*1,'APU Scale'!A:B,2,FALSE)-G95,-2))","v":0},{"$f":"ROUND(H95*VLOOKUP(B95*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P96,'FY24-FY25 Scales'!A:J,10,FALSE),G96)","v":0},{"$f":"IFERROR(VLOOKUP(P96,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G96*VLOOKUP(B96*1,'APU Scale'!A:B,2,FALSE)-G96,-2))","v":0},{"$f":"ROUND(H96*VLOOKUP(B96*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P97,'FY24-FY25 Scales'!A:J,10,FALSE),G97)","v":0},{"$f":"IFERROR(VLOOKUP(P97,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G97*VLOOKUP(B97*1,'APU Scale'!A:B,2,FALSE)-G97,-2))","v":0},{"$f":"ROUND(H97*VLOOKUP(B97*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P98,'FY24-FY25 Scales'!A:J,10,FALSE),G98)","v":0},{"$f":"IFERROR(VLOOKUP(P98,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G98*VLOOKUP(B98*1,'APU Scale'!A:B,2,FALSE)-G98,-2))","v":0},{"$f":"ROUND(H98*VLOOKUP(B98*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P99,'FY24-FY25 Scales'!A:J,10,FALSE),G99)","v":0},{"$f":"IFERROR(VLOOKUP(P99,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G99*VLOOKUP(B99*1,'APU Scale'!A:B,2,FALSE)-G99,-2))","v":0},{"$f":"ROUND(H99*VLOOKUP(B99*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P100,'FY24-FY25 Scales'!A:J,10,FALSE),G100)","v":0},{"$f":"IFERROR(VLOOKUP(P100,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G100*VLOOKUP(B100*1,'APU Scale'!A:B,2,FALSE)-G100,-2))","v":0},{"$f":"ROUND(H100*VLOOKUP(B100*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P101,'FY24-FY25 Scales'!A:J,10,FALSE),G101)","v":0},{"$f":"IFERROR(VLOOKUP(P101,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G101*VLOOKUP(B101*1,'APU Scale'!A:B,2,FALSE)-G101,-2))","v":0},{"$f":"ROUND(H101*VLOOKUP(B101*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P102,'FY24-FY25 Scales'!A:J,10,FALSE),G102)","v":0},{"$f":"IFERROR(VLOOKUP(P102,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G102*VLOOKUP(B102*1,'APU Scale'!A:B,2,FALSE)-G102,-2))","v":0},{"$f":"ROUND(H102*VLOOKUP(B102*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P103,'FY24-FY25 Scales'!A:J,10,FALSE),G103)","v":0},{"$f":"IFERROR(VLOOKUP(P103,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G103*VLOOKUP(B103*1,'APU Scale'!A:B,2,FALSE)-G103,-2))","v":0},{"$f":"ROUND(H103*VLOOKUP(B103*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P104,'FY24-FY25 Scales'!A:J,10,FALSE),G104)","v":0},{"$f":"IFERROR(VLOOKUP(P104,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G104*VLOOKUP(B104*1,'APU Scale'!A:B,2,FALSE)-G104,-2))","v":0},{"$f":"ROUND(H104*VLOOKUP(B104*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P105,'FY24-FY25 Scales'!A:J,10,FALSE),G105)","v":0},{"$f":"IFERROR(VLOOKUP(P105,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G105*VLOOKUP(B105*1,'APU Scale'!A:B,2,FALSE)-G105,-2))","v":0},{"$f":"ROUND(H105*VLOOKUP(B105*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P106,'FY24-FY25 Scales'!A:J,10,FALSE),G106)","v":0},{"$f":"IFERROR(VLOOKUP(P106,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G106*VLOOKUP(B106*1,'APU Scale'!A:B,2,FALSE)-G106,-2))","v":0},{"$f":"ROUND(H106*VLOOKUP(B106*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},{"$f":"K106+L106+M106","v":0},{"$f":"IF(I106-J106-N106<0,0,I106-J106-N106)","v":0},{"$f":"CONCATENATE(E106,F106,B106)","v":"0"}]
[{"$f":"A106","v":0},{"$f":"B106","v":0},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P107,'FY24-FY25 Scales'!A:J,10,FALSE),G107)","v":0},{"$f":"IFERROR(VLOOKUP(P107,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G107*VLOOKUP(B107*1,'APU Scale'!A:B,2,FALSE)-G107,-2))","v":0},{"$f":"ROUND(H107*VLOOKUP(B107*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P108,'FY24-FY25 Scales'!A:J,10,FALSE),G108)","v":0},{"$f":"IFERROR(VLOOKUP(P108,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G108*VLOOKUP(B108*1,'APU Scale'!A:B,2,FALSE)-G108,-2))","v":0},{"$f":"ROUND(H108*VLOOKUP(B108*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P109,'FY24-FY25 Scales'!A:J,10,FALSE),G109)","v":0},{"$f":"IFERROR(VLOOKUP(P109,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G109*VLOOKUP(B109*1,'APU Scale'!A:B,2,FALSE)-G109,-2))","v":0},{"$f":"ROUND(H109*VLOOKUP(B109*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P110,'FY24-FY25 Scales'!A:J,10,FALSE),G110)","v":0},{"$f":"IFERROR(VLOOKUP(P110,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G110*VLOOKUP(B110*1,'APU Scale'!A:B,2,FALSE)-G110,-2))","v":0},{"$f":"ROUND(H110*VLOOKUP(B110*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P111,'FY24-FY25 Scales'!A:J,10,FALSE),G111)","v":0},{"$f":"IFERROR(VLOOKUP(P111,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G111*VLOOKUP(B111*1,'APU Scale'!A:B,2,FALSE)-G111,-2))","v":0},{"$f":"ROUND(H111*VLOOKUP(B111*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P112,'FY24-FY25 Scales'!A:J,10,FALSE),G112)","v":0},{"$f":"IFERROR(VLOOKUP(P112,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G112*VLOOKUP(B112*1,'APU Scale'!A:B,2,FALSE)-G112,-2))","v":0},{"$f":"ROUND(H112*VLOOKUP(B112*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P113,'FY24-FY25 Scales'!A:J,10,FALSE),G113)","v":0},{"$f":"IFERROR(VLOOKUP(P113,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G113*VLOOKUP(B113*1,'APU Scale'!A:B,2,FALSE)-G113,-2))","v":0},{"$f":"ROUND(H113*VLOOKUP(B113*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P114,'FY24-FY25 Scales'!A:J,10,FALSE),G114)","v":0},{"$f":"IFERROR(VLOOKUP(P114,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G114*VLOOKUP(B114*1,'APU Scale'!A:B,2,FALSE)-G114,-2))","v":0},{"$f":"ROUND(H114*VLOOKUP(B114*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P115,'FY24-FY25 Scales'!A:J,10,FALSE),G115)","v":0},{"$f":"IFERROR(VLOOKUP(P115,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G115*VLOOKUP(B115*1,'APU Scale'!A:B,2,FALSE)-G115,-2))","v":0},{"$f":"ROUND(H115*VLOOKUP(B115*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P116,'FY24-FY25 Scales'!A:J,10,FALSE),G116)","v":0},{"$f":"IFERROR(VLOOKUP(P116,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G116*VLOOKUP(B116*1,'APU Scale'!A:B,2,FALSE)-G116,-2))","v":0},{"$f":"ROUND(H116*VLOOKUP(B116*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P117,'FY24-FY25 Scales'!A:J,10,FALSE),G117)","v":0},{"$f":"IFERROR(VLOOKUP(P117,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G117*VLOOKUP(B117*1,'APU Scale'!A:B,2,FALSE)-G117,-2))","v":0},{"$f":"ROUND(H117*VLOOKUP(B117*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P118,'FY24-FY25 Scales'!A:J,10,FALSE),G118)","v":0},{"$f":"IFERROR(VLOOKUP(P118,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G118*VLOOKUP(B118*1,'APU Scale'!A:B,2,FALSE)-G118,-2))","v":0},{"$f":"ROUND(H118*VLOOKUP(B118*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P119,'FY24-FY25 Scales'!A:J,10,FALSE),G119)","v":0},{"$f":"IFERROR(VLOOKUP(P119,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G119*VLOOKUP(B119*1,'APU Scale'!A:B,2,FALSE)-G119,-2))","v":0},{"$f":"ROUND(H119*VLOOKUP(B119*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P120,'FY24-FY25 Scales'!A:J,10,FALSE),G120)","v":0},{"$f":"IFERROR(VLOOKUP(P120,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G120*VLOOKUP(B120*1,'APU Scale'!A:B,2,FALSE)-G120,-2))","v":0},{"$f":"ROUND(H120*VLOOKUP(B120*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P121,'FY24-FY25 Scales'!A:J,10,FALSE),G121)","v":0},{"$f":"IFERROR(VLOOKUP(P121,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G121*VLOOKUP(B121*1,'APU Scale'!A:B,2,FALSE)-G121,-2))","v":0},{"$f":"ROUND(H121*VLOOKUP(B121*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P122,'FY24-FY25 Scales'!A:J,10,FALSE),G122)","v":0},{"$f":"IFERROR(VLOOKUP(P122,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G122*VLOOKUP(B122*1,'APU Scale'!A:B,2,FALSE)-G122,-2))","v":0},{"$f":"ROUND(H122*VLOOKUP(B122*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P123,'FY24-FY25 Scales'!A:J,10,FALSE),G123)","v":0},{"$f":"IFERROR(VLOOKUP(P123,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G123*VLOOKUP(B123*1,'APU Scale'!A:B,2,FALSE)-G123,-2))","v":0},{"$f":"ROUND(H123*VLOOKUP(B123*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P124,'FY24-FY25 Scales'!A:J,10,FALSE),G124)","v":0},{"$f":"IFERROR(VLOOKUP(P124,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G124*VLOOKUP(B124*1,'APU Scale'!A:B,2,FALSE)-G124,-2))","v":0},{"$f":"ROUND(H124*VLOOKUP(B124*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P125,'FY24-FY25 Scales'!A:J,10,FALSE),G125)","v":0},{"$f":"IFERROR(VLOOKUP(P125,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G125*VLOOKUP(B125*1,'APU Scale'!A:B,2,FALSE)-G125,-2))","v":0},{"$f":"ROUND(H125*VLOOKUP(B125*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P126,'FY24-FY25 Scales'!A:J,10,FALSE),G126)","v":0},{"$f":"IFERROR(VLOOKUP(P126,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G126*VLOOKUP(B126*1,'APU Scale'!A:B,2,FALSE)-G126,-2))","v":0},{"$f":"ROUND(H126*VLOOKUP(B126*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P127,'FY24-FY25 Scales'!A:J,10,FALSE),G127)","v":0},{"$f":"IFERROR(VLOOKUP(P127,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G127*VLOOKUP(B127*1,'APU Scale'!A:B,2,FALSE)-G127,-2))","v":0},{"$f":"ROUND(H127*VLOOKUP(B127*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P128,'FY24-FY25 Scales'!A:J,10,FALSE),G128)","v":0},{"$f":"IFERROR(VLOOKUP(P128,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G128*VLOOKUP(B128*1,'APU Scale'!A:B,2,FALSE)-G128,-2))","v":0},{"$f":"ROUND(H128*VLOOKUP(B128*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P129,'FY24-FY25 Scales'!A:J,10,FALSE),G129)","v":0},{"$f":"IFERROR(VLOOKUP(P129,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G129*VLOOKUP(B129*1,'APU Scale'!A:B,2,FALSE)-G129,-2))","v":0},{"$f":"ROUND(H129*VLOOKUP(B129*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P130,'FY24-FY25 Scales'!A:J,10,FALSE),G130)","v":0},{"$f":"IFERROR(VLOOKUP(P130,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G130*VLOOKUP(B130*1,'APU Scale'!A:B,2,FALSE)-G130,-2))","v":0},{"$f":"ROUND(H130*VLOOKUP(B130*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P131,'FY24-FY25 Scales'!A:J,10,FALSE),G131)","v":0},{"$f":"IFERROR(VLOOKUP(P131,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G131*VLOOKUP(B131*1,'APU Scale'!A:B,2,FALSE)-G131,-2))","v":0},{"$f":"ROUND(H131*VLOOKUP(B131*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P132,'FY24-FY25 Scales'!A:J,10,FALSE),G132)","v":0},{"$f":"IFERROR(VLOOKUP(P132,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G132*VLOOKUP(B132*1,'APU Scale'!A:B,2,FALSE)-G132,-2))","v":0},{"$f":"ROUND(H132*VLOOKUP(B132*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P133,'FY24-FY25 Scales'!A:J,10,FALSE),G133)","v":0},{"$f":"IFERROR(VLOOKUP(P133,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G133*VLOOKUP(B133*1,'APU Scale'!A:B,2,FALSE)-G133,-2))","v":0},{"$f":"ROUND(H133*VLOOKUP(B133*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P134,'FY24-FY25 Scales'!A:J,10,FALSE),G134)","v":0},{"$f":"IFERROR(VLOOKUP(P134,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G134*VLOOKUP(B134*1,'APU Scale'!A:B,2,FALSE)-G134,-2))","v":0},{"$f":"ROUND(H134*VLOOKUP(B134*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P135,'FY24-FY25 Scales'!A:J,10,FALSE),G135)","v":0},{"$f":"IFERROR(VLOOKUP(P135,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G135*VLOOKUP(B135*1,'APU Scale'!A:B,2,FALSE)-G135,-2))","v":0},{"$f":"ROUND(H135*VLOOKUP(B135*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P136,'FY24-FY25 Scales'!A:J,10,FALSE),G136)","v":0},{"$f":"IFERROR(VLOOKUP(P136,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G136*VLOOKUP(B136*1,'APU Scale'!A:B,2,FALSE)-G136,-2))","v":0},{"$f":"ROUND(H136*VLOOKUP(B136*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P137,'FY24-FY25 Scales'!A:J,10,FALSE),G137)","v":0},{"$f":"IFERROR(VLOOKUP(P137,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G137*VLOOKUP(B137*1,'APU Scale'!A:B,2,FALSE)-G137,-2))","v":0},{"$f":"ROUND(H137*VLOOKUP(B137*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P138,'FY24-FY25 Scales'!A:J,10,FALSE),G138)","v":0},{"$f":"IFERROR(VLOOKUP(P138,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G138*VLOOKUP(B138*1,'APU Scale'!A:B,2,FALSE)-G138,-2))","v":0},{"$f":"ROUND(H138*VLOOKUP(B138*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},{"$f":"K138+L138+M138","v":0},{"$f":"IF(I138-J138-N138<0,0,I138-J138-N138)","v":0},"0"]
[0,0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P139,'FY24-FY25 Scales'!A:J,10,FALSE),G139)","v":0},{"$f":"IFERROR(VLOOKUP(P139,'FY24-FY25 Scales'!A:K,11,FALSE),ROUND(G139*VLOOKUP(B139*1,'APU Scale'!A:B,2,FALSE)-G139,-2))","v":0},{"$f":"ROUND(H139*VLOOKUP(B139*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"0"]

{"sheet":"APU Master","index":3,"n_rows":92,"n_cols":22,"rows_kept":92,"cut":false,"hidden":true,"merged":[[2,5,2,9],[2,10,2,16],[2,17,2,21]]}
["as of 12/16/25"]
["APU Master List"]
[null,null,null,null,null,"EFFECTIVE UP UNTIL 7/1/23",null,null,null,null,"CHANGES EFFECTIVE 7/1/24",null,null,null,null,null,null,"EFFECTIVE UP UNTIL 7/1/24"]
["Department/School","APU Code","Scale","APU Name","APU Definition","APU profile form - last approved","Effective ","Memo (Y/N)","APU profile form (Y/N)","ARC case # (PRIOR TO 7/1/24)","ARC case #","Change Requested (brief description)","Memo - provided (Y/N)","APU profile form signed (Y/N - if N, who is pending)","Dean/VC approval (Y/N)","Date","Note","APU profile form - last approved - 2024","Effective - as of 2024","Memo (Y/N) - as of 2024","APU profile form (Y/N) - as of 2024","ARC case # - as of 2024"]
["Anesthesiology","ANE001",5,"Anesthesiology Clinical Faculty","All clinical faculty members in department.","2022-01-14","2021-07-01","N","Y","ARC0308941",null,null,null,null,null,null,null,"2022-01-14","2021-07-01","N","Y","ARC0308941"]
["Cellular & Molecular Medicine","CMM001",4,"Cellular & Molecular Medicine","Faculty with primary appointment in the Department of Cellular and Molecular Medicine.","N","N","N","N","N","ARC0372779","no change - replacing expired","N/A","Y","Y","2024-04-26","Approved","2024-04-26","2024-07-01","N/A","Y","ARC0372779"]
["Dermatology ","MED043",3,"Dermatology Clinical Faculty","Clinically active faculty members in the Division of Dermatology.","N","N","N","N","N",null,null,null,null,null,null,null,"N","N","N","N","N"]
["Dermatology ","PEDDER",7,"Dermatology  ","Pediatric Derm faculty hired under the Department of Pediatrics before the establishment of the Department of Dermatology in 2015.  Peds Derm faculty hired post department establishment are at APU 3 to align with Adult Derm faculty.","N","N","N","N","N","ARC0372708","no change - replacing expired","N/A","N","N","2024-06-12","pending dept.","N","N","N","N","N"]
["Emergency Medicine","EMS001",7,"DEM Faculty Leadership (EMS)","All faculty board certified in Emergency Medicine with active clinical, teaching, and scholarly profiles and have current major administrative and academic leadership positions or responsibilities, and must be long term positions within the department (e.g., Chair, Vice Chair, etc.).","N","N","N","N","N","ARC0372721","changed description (All faculty board certified in Emergency Medicine with active clinical, teaching, and scholarly profiles and have current major administrative and academic leadership positions or responsibilities, and must be long term positions within the department (e.g., Chair, Vice Chair, etc.)","Y","Y","Y","2024-06-11","Approved","2024-06-11","2024-07-01","Y","Y","ARC0372721"]
["Emergency Medicine","EMS002",6,"DEM Faculty (EMS)","Full-time EMS faculty carrying full clinical responsibility along with teaching and scholarly productivity requirements.","N","N","N","N","N","ARC0372721","changed description (Full-time EMS faculty carrying full clinical responsibility along with teaching and scholarly productivity requirements.)","Y","Y","Y","2024-06-12","Approved","2024-06-12","2024-07-01","Y","Y","ARC0372721"]
["Family Medicine","FPM001",5,"Family Medicine Physician and Leadership Faculty","All department faculty with medical doctoral degree (e.g. MD, DO) and/or Vice Chairs and Division Chiefs with or without medical doctoral degree (e.g. MD, DO, PhD, PsyD).","2022-04-07","2022-07-01","Y","Y","ARC0326004","ARC0372714","change name + definition (All department faculty with medical doctoral degree (e.g. MD, DO) and/or current Vice Chairs and Division Chiefs with or without medical doctoral degree (e.g. MD, DO, PhD, PsyD.) - affecting Drs. Sieber and Tai-Seale (FPM002 to FPM001)","Y","Y","Y","2024-06-11","Approved","2024-06-11","2024-07-01","Y","Y","ARC0372714"]
["Family Medicine","FPM002",3,"Family Medicine Non-Physician Faculty","All department faculty with non-medical doctoral degrees (e.g. PhD, PsyD).","2022-04-07","2022-07-01","Y","Y","ARC0326005","ARC0372714","change name + definition + has less than 5 members so require VC exceptional approval","Y","Y","Y","2024-06-11","Approved","2024-06-11","2024-07-01","Y","Y","ARC0372714"]
["Family Medicine","FPM003",5,"Family Medicine PACE Faculty","All department faculty who are PACE (Physician Assessment Clinical Ed) Program faculty directors.","2022-04-07","2022-07-01","Y","Y","ARC0326006","ARC0372714","change name + definition ","Y","Y","Y","2024-06-11","Approved","2024-06-11","2024-07-01","Y","Y","ARC0372714"]
["Medicine","MED031",3,"Genomics & Precision Medicine Faculty","Clinically active and Research faculty members in the Division of Genomics & Precision Medicine.","2023-05-12","2023-07-01","N","Y","N","ARC0370194","changed APU name + description to reflect new division name (Genomics & Precision Medicine Faculty - Clinically active and Research faculty members in the Division of Genomics & Precision Medicine.)","Y","Y","Y","2024-04-22","Approved","2024-04-22","2024-07-01","Y","Y","ARC0370194"]
["Medicine","MED041",3,"Bone Marrow Transplantation Faculty","Clinically active faculty members in the Division of Bone Marrow Transplant.","2023-05-12","2023-07-01","Y","Y","N","ARC0372870","various Faculty changing APU","N","N","N","2024-04-22","pending dept.","2023-05-12","2023-07-01","Y","Y","N"]
["Medicine","MED042",3,"Cardiovascular Medicine Clinical & Research Faculty","Clinically active and Research faculty members in the Division of Cardiovascular Medicine.","2023-05-12","2023-07-01","Y","Y","N","ARC0372870","various Faculty changing APU","N","N","N","2024-04-22","pending dept.","2023-05-12","2023-07-01","Y","Y","N"]
["Medicine","MED044",3,"Endocrinology/Metabolism Clinical & Research Faculty","Clinically active and Research faculty members in the Division of Endocrinology/Metabolism.","2023-05-12","2023-07-01","Y","Y","N","ARC0372870","various Faculty changing APU","N","N","N","2024-04-22","pending dept.","2023-05-12","2023-07-01","Y","Y","N"]
["Medicine","MED045",3,"Gastroenterology/Hepatology Clinical & Research Faculty","Clinically  active and Research faculty members in the Division of Gastroenterology/Hepatology.","2023-05-12","2023-07-01","Y","Y","ARC0351533","ARC0372870","various Faculty changing APU","N","N","N","2024-04-22","pending dept.","2023-05-12","2023-07-01","Y","Y","ARC0351533"]
["Medicine","MED046",3,"General Internal Medicine Clinical & Research Faculty","Clinically active and Research faculty members in the Division of General Internal Medicine.","2023-05-12","2023-07-01","Y","Y","N","ARC0372870","various Faculty changing APU","N","N","N","2024-04-22","pending dept.","2023-05-12","2023-07-01","Y","Y","N"]
["Medicine","MED048",3,"Hematology/Oncology Clinical & Research Faculty","Clinically active and Research faculty members in the Division of Hematology/Oncology.","2023-05-12","2023-07-01","Y","Y","N","ARC0372870","various Faculty changing APU","N","N","N","2024-04-22","pending dept.","2023-05-12","2023-07-01","Y","Y","N"]
["Medicine","MED049",3,"Hospital Medicine Clinical Faculty","Clinically active faculty members in the Division of Hospital Medicine.","2023-05-12","2023-07-01","Y","Y","N","ARC0372870","various Faculty changing APU","N","N","N","2024-04-22","pending dept.","2023-05-12","2023-07-01","Y","Y","N"]
["Medicine","MED050",3,"Infectious Diseases Clinical & Research Faculty","Clinically active and Research faculty members in the Division of Infectious Diseases.","2023-05-12","2023-07-01","Y","Y","N","ARC0372870","various Faculty changing APU","N","N","N","2024-04-22","pending dept.","2023-05-12","2023-07-01","Y","Y","N"]
["Medicine","MED051",3,"Nephrology Clinical & Research Faculty","Clinically active and Research faculty members in the Division of Nephrology.","2023-05-12","2023-07-01","Y","Y","N","ARC0372870","various Faculty changing APU","N","N","N","2024-04-22","pending dept.","2023-05-12","2023-07-01","Y","Y","N"]
["Medicine","MED053",3,"Pulmonary Clinical & Research Faculty","Clinically active and Research faculty members in the Division of Pulmonary.","2023-05-12","2023-07-01","Y","Y","N","ARC0372870","various Faculty changing APU","N","N","N","2024-04-22","pending dept.","2023-05-12","2023-07-01","Y","Y","N"]
["Medicine","MED054",3,"Rheumatology, Autoimmunity and Inflammation and Allergy and Immunology Faculty","Clinically active and Research faculty members in the Division of Rheumatology, Autoimmunity and Inflammation and the Division of Allergy and Immunology.","2023-05-12","2023-07-01","N","Y","N","ARC0370194","changed APU name + description to reflect new division name (Rheumatology, Autoimmunity and Inflammation and Allergy and Immunology Faculty - Clinically active and Research faculty members in the Division of Rheumatology, Autoimmunity and Inflammation and the Division of Allergy and Immunology.)","Y","Y","Y","2024-04-22","Approved","2024-04-22","2024-07-01","Y","Y","ARC0370194"]
["Medicine","MED055",3,"Owens Clinical & Research Faculty","Clinically active and Research faculty members in the Division Owens Clinic.","2023-05-12","2023-07-01","Y","Y","N","ARC0372870","various Faculty changing APU","N","N","N","2024-04-22","pending dept.","2023-05-12","2023-07-01","Y","Y","N"]
["Medicine","MED056",7,"Endocrinology/Metabolism APU7","Board Certified Endocrinologists with Academic Senate membership in FTE or IR series who are eligible for 100% UCRP participation.","2023-05-12","2023-07-01","N","Y","N","ARC0372870","various Faculty changing APU","N","N","N","2024-04-22","pending dept.","2023-05-12","2023-07-01","N","Y","N"]
["Medicine","MED074",3,"Geriatrics, Gerontology and Palliative Care Faculty","Clinically active and Research faculty members in the Division of Geriatrics, Gerontology and Palliative Care.","2023-05-12","2023-07-01","Y","Y","N","ARC0370194","changed APU name + description to reflect new division name (Geriatrics, Gerontology and Palliative Care Faculty - Clinically active and Research faculty members in the Division of Geriatrics, Gerontology and Palliative Care.)","Y","Y","Y","2024-04-22","Approved","2024-04-22","2024-07-01","Y","Y","ARC0370194"]
["Medicine","MED076",5,"Department's Division Chief Faculty (present and former)","DOM faculty members assigned as Division Chiefs as well as Department leadership positions\nas assigned by the Chair Person. Effective FY24 membership in this APU is assigned for the\nduration of the leadership term.","2023-05-12","2023-07-01","Y","Y","N","ARC0372870","various Faculty changing APU","N","N","N","2024-04-22","pending dept.","2023-05-12","2023-07-01","Y","Y","N"]
["Medicine","MED077",3,"Global Public Health Faculty","Clinically active and Research faculty members in the Division of Global Public Health.","2023-05-12","2023-07-01","Y","Y","N","ARC0372870","various Faculty changing APU","N","N","N","2024-04-22","pending dept.","2023-05-12","2023-07-01","Y","Y","N"]
["Medicine","MED078",3,"Biomedical Informatics Clinical & Research Faculty","Clinically active and Research faculty members in the Division of Biomedical Informatics.","2023-10-27","2023-07-01","Y","Y","ARC0362356","ARC0372870","various Faculty changing APU","N","N","N","2024-04-22","pending dept.","2023-10-27","2023-07-01","Y","Y","ARC0362356"]
["Medicine","MED079",3,"Regenerative Medicine Clinical & Research Faculty","Clinically active and Research faculty members in the Division of Regenerative Medicine.","2023-05-12","2023-07-01","N","Y","N","ARC0372870","various Faculty changing APU","N","N","N","2024-04-22","pending dept.","2023-05-12","2023-07-01","N","Y","N"]
["Medicine","MED100",0,"DOM Non-Clinical APU0","PhD, non-licensed MD and/or PhD/MD faculty members in the DOM who are research oriented and without clinical duties. Similar research would include faculty members who investigate the patho-physiological and molecular basis of diseases.","2023-05-12","2023-07-01","Y","Y","N","ARC0372870","various Faculty changing APU","N","N","N","2024-04-22","pending dept.","2023-05-12","2023-07-01","Y","Y","N"]
["Neurological Surgery","NSG001",9,"Neurological Surgery Clinical Faculty","Clinically active faculty members in the Department of Neurological Surgery","N","2023-07-01","N","Y","N","ARC0372717","no change - missing/expired","N/A","Y","Y","2024-04-29","Approved","2024-04-29","2024-07-01","N/A","Y","ARC0372717"]
["Neurosciences","NEU001",1,"Neurosciences Basic Scientists","Ph.D.s in the Department of Neurosciences","2023-05-12","2023-07-01","N","Y","ARC0347363",null,null,null,null,null,null,null,"2023-05-12","2023-07-01","N","Y","ARC0347363"]
["Neurosciences","NEU003",3,"Neurosciences Clinicians","M.D.s in the Department of Neurosciences","2023-05-12","2023-07-01","Y","Y","ARC0347364","ARC0372747","moving Dr. Bui from SOMVA1 to NEU003","Y","Y","Y","2024-05-02","Approved","2024-05-02","2024-07-01","Y","Y","ARC0372747"]
["Neurosciences","NEUCHR",6,"Neurosciences Chairs/Vice Chairs/ORU Directors","Chair, Vice Chair/Directors of ORUs or other major, large-scale projects in the Dept of Neurosciences.","2023-05-12","2023-07-01","Y","Y","ARC0347365",null,null,null,null,null,null,null,"2023-05-12","2023-07-01","Y","Y","ARC0347365"]
["OBGYN & Reproductive Sciences","RPR001",7,"Reproductive Medicine Clinical Faculty","Clinical faculty.","N","N","N","N","N","ARC0372715","no change - missing/expired","N/A","Y","Y","2024-05-03","Approved","2024-05-03","2024-07-01","N/A","Y","ARC0372715"]
["OBGYN & Reproductive Sciences","RPR003",3,"Reproductive Medicine Other PhD Faculty","Reproductive Medicine Other PhD Faculty","N","N","N","N","N","ARC0372715","no change - missing/expired","N/A","Y","Y","2024-05-03","Approved","2024-05-03","2024-07-02","N/A","Y","ARC0372715"]
["OBGYN & Reproductive Sciences","RPR004",6,"Center Grant Directors, Co-Directors, Core Directors","All research Ph.D. faculty who are Directors, Co-Directors &/or Core Directors of a Center Grant.","N","N","N","N","N","ARC0372715","no change - missing/expired","N/A","Y","Y","2024-05-03","Approved","2024-05-03","2024-07-03","N/A","Y","ARC0372715"]
["Ophthalmology","OPH001",9,"Ophthalmology Surgical Clinical Faculty","Ophthalmology Surgical Clinical Faculty","2021-08-12","2021-07-01","N","Y","N",null,null,null,null,null,null,null,"2021-08-12","2021-07-01","N","Y","N"]
["Ophthalmology","OPHGCP",2,"Ophthalmology Ph.D. Faculty","Academics spending 80% or more time on research & academics with a valid 2113 allowing for patient care activities in addition to their research.","2021-08-12","2021-07-01","N","Y","N",null,null,null,null,null,null,null,"2021-08-12","2021-07-01","N","Y","N"]
["Orthopaedic Surgery","ORT001",6,"Orthopaedics Clinical Faculty","UCSD Orthopaedic Surgery faculty whose primary function is adult clinical care surgeons. ","2024-04-10","2024-07-01","Y","Y",null,"ARC0363910","changed description (UCSD Orthopaedic Surgery faculty whose primary function is adult clinical care surgeons. )","Y","Y","Y","2024-04-10","Approved","2024-04-10","2024-07-01","Y","Y","ARC0363910"]
["Orthopaedic Surgery","ORT002",3,"Ortho Surgery Research Faculty","Ph.D. and M.D. faculty whose primary function is research","2021-08-12","2021-07-01","Y","Y","N",null,null,null,null,null,null,null,"2021-08-12","2021-07-01","Y","Y","N"]
["Orthopaedic Surgery","ORT004",6,"Ortho Surg Fac w/Vice Chair/Residency Directorship","Orthopaedic Surgery faculty holding title of Vice Chair or Residency Director & involved in the administration of the various missions of the department.","2021-08-09","2021-07-01","Y","Y","N",null,null,null,null,null,null,null,"2021-08-09","2021-07-01","Y","Y","N"]
["Orthopaedic Surgery","ORT005","8","Ortho Surg Children's Faculty","Orthopaedic Surgery faculty whose primary function is as pediatric surgeons with the majority (51% or more) of their time at Rady Children’s Hospital, associated clinics, and research labs.","N","N","N","N","N","ARC0363910","changed scale from 9 - 6 (starting FY25 at 8, etc.) + definition (Orthopaedic Surgery faculty whose primary function is as pediatric surgeons with the majority (51% or more) of their time at Rady Children’s Hospital, associated clinics, and research labs.)","Y","Y","Y","2024-06-11","Approved","2024-06-11","2024-07-01","Y","Y","ARC0363910"]
["Orthopaedic Surgery","ORT006",3,"Orthopaedic Surgery Non-Surgical Faculty ","UCSD Orthopaedic Surgery faculty whose primary function is the non-surgical care of patients at UCSD Medical Center and associated clinics. ","N","N","N","N","N","ARC0363910","change scale from 3 to 4 & description (UCSD Orthopaedic Surgery faculty whose primary function is procedures and the non-surgical care of patients.) ","N","N","N","2024-02-09","pending Dean","N","N","N","N","N"]
["Pathology","PTH002",2,"Faculty who teach or research veterinary medicine","Faculty will teach or research veterinary medicine, focus upon clinical &/or resident & graduate student instruction into comparative pathology & medicine.","2023-05-15","2023-07-01","N","Y","N",null,null,null,null,null,null,null,"2023-05-15","2023-07-01","N","Y","N"]
["Pathology","PTH003",4,"Pathology Clinically Active Faculty","All clinically active faculty regardless of subspecialty in Pathology.","2023-05-15","2023-07-01","Y","Y","N",null,null,null,null,null,null,null,"2023-05-15","2023-07-01","Y","Y","N"]
["Pathology","PTH004",5,"Executive Leadership Committee","Specific division heads, including clinical path, anatomic path, neuropathology & Vice Chair Res. Members of APU will have MD and PhD degrees. Exe Leadership Com will focus on advising Chair on clinical, res & education issues, develop & implement policy.","2023-05-15","2023-07-01","Y","Y","N",null,null,null,null,null,null,null,"2023-05-15","2023-07-01","Y","Y","N"]
["Pathology","PTH005",3,"Department Based Ph.D. Scientists","Ph.D. scientists who are engaged in substantial teaching activities for SOM, SSOP &/or graduate studies. Must teach 50 contact hours in SOM, SOP &/or grad school program core courses each 12 months.","2023-05-15","2023-07-01","N","Y","N",null,null,null,null,null,null,null,"2023-05-15","2023-07-01","N","Y","N"]
["Pediatrics","PEDCAR",7,"Cardiology & Gastroenterology","Clinically active faculty specializing in Pediatric Cardiology, Critical Care, Gastroenterology, Hepatology, and Nutrition","2023-06-01","2023-07-01","N","Y","ARC0347405","ARC0372718","change definition (Clinically active faculty specializing in Pediatric Cardiology, Critical Care, Gastroenterology, Hepatology, and Nutrition.) + moving Coufal from PEDPED to PEDCAR","Y","Y","Y","2024-05-20","Approved","2024-05-20","2024-07-01","Y","Y","ARC0372718"]
["Pediatrics","PEDEME",5,"Emergency Medicine, Infectious Diseases, Respiratory Medicine","Clinically active faculty specializing in Pediatric Emergency Medicine, Infectious Diseases, and Respiratory Medicine\n","2023-06-01","2023-07-01","N","Y","ARC0347405",null,null,null,null,null,null,null,"2023-06-01","2023-07-01","N","Y","ARC0347405"]
["Pediatrics","PEDNEO",9,"Neonatology","Clinically active faculty specializing in Pediatric Neonatology.","2023-06-01","2023-07-01","N","Y","ARC0347405",null,null,null,null,null,null,null,"2023-06-01","2023-07-01","N","Y","ARC0347405"]
["Pediatrics","PEDPED",3,"Pediatric Subspecialties","Clinically active faculty specializing in Pediatrics Allergy, Immunology, Rheumatology, General Pediatrics, Newborn Medicine, and Developmental‐Behavioral Pediatrics, Adolescent Medicine, Child Abuse Pediatrics,\nEndocrinology, Environmental Science & Health, Genetics, Genomics, Hematology & Oncology, Hospital\nMedicine, Host‐Microbe Systems & Therapeutics, Nephrology, Palliative Care, Urgent Care.","2023-06-01","2023-07-01","N","Y","ARC0347405","ARC0372718","change the definition moving Coufal from PEDPED to PEDCAR","Y","Y","Y","2024-05-20","Approved","2024-05-20","2024-07-01","Y","Y","ARC0372718"]
["Pediatrics","PEDPHD",3,"PhD Faculty & Non-clinically Active MD Faculty","PhD and non‐clinically active MD faculty whose primary function is research","2023-06-01","2023-07-01","N","Y","ARC0347405",null,null,null,null,null,null,null,"2023-06-01","2023-07-01","N","Y","ARC0347405"]
["Pharmacology","PHR000",0,"Other Research","This APU is reserved for those investigators without an extramurally funded independent research program* or those with less than a full FTE. Faculty who qualify for a higher APU can voluntarily choose to belong to a lower APU.\n\n*An investigator without an extramurally funded independent research program is one who does not serve as Principal Investigator on one or more active research grant or contract, or direct a project/core on a PPG.","2022-05-31","2022-07-01","Y","Y","N",null,null,null,null,null,null,null,"2022-05-31","2022-07-01","Y","Y","N"]
["Pharmacology","PHR001",1,"Teaching & Research Group II","Consists of faculty who have not participated in integrated research programs that insure continuous research activity and support mechanisms or faculty having heavy administrative commitments.","2022-06-01","2022-07-02","Y","Y","N","ARC0372727","moving Sunahara from PHR003 to PHR001","Y","Y","Y","2024-05-10","Approved","2024-05-10","2024-07-01","Y","Y","ARC0372727"]
["Pharmacology","PHR003",3,"Coordinated Research & Teaching Unit","Formed by faculty group who conduct coordinated research and teaching activities.  Activities include graduate student and fellow training, weekly research discussions, participation in centers and program projects supported for extended periods.","2022-06-01","2022-07-03","Y","Y","N","ARC0372727","moving Sunahara from PHR003 to PHR001","Y","Y","Y","2024-05-10","Approved","2024-05-10","2024-07-01","Y","Y","ARC0372727"]
["Psychiatry","PST002",2,"PhD Clinical Faculty ","Non-medical doctoral degree (e.g., PhD, PsyD) with patient contact at UCSD or affiliate site.","2023-06-09","2023-07-01","Y","Y","N","ARC0372703","various Faculty changing APU","Y - inadequate","Y","N","2024-06-10","pending dept.","2023-06-09","2023-07-01","Y","Y","N"]
["Psychiatry","PST003",3,"MD or Externally Funded Faculty","1. Medical degree (e.g., MD, DO) with patient contact at UCSD or affiliate site; or \n2. Externally-funded project.","2023-06-09","2023-07-01","Y","Y","N","ARC0372703","various Faculty changing APU","Y - inadequate","Y","N","2024-06-10","pending dept.","2023-06-09","2023-07-01","Y","Y","N"]
["Psychiatry","PST004",4,"Faculty with Significant Administrative Functions","1. Significant administrative functions (e.g., Associate Vice Chair); or \n2. Training program lead role (e.g., T32 or R25).","2023-06-09","2023-07-01","Y","Y","N","ARC0372703","various Faculty changing APU","Y - inadequate","Y","N","2024-06-10","pending dept.","2023-06-09","2023-07-01","Y","Y","N"]
["Psychiatry","PST005",5,"Faculty Directing Complex Programs","1. Major administrative functions (e.g., Vice Chair, Division Chief, ORU Director), or \n2. Major training program director role (e.g., Joint Doctoral Program in Clinical Psychology, Adult Residency Training), or\n3. Major, large-scale projects.","2023-06-09","2023-07-01","Y","Y","N","ARC0372703","various Faculty changing APU","Y - inadequate","Y","N","2024-06-10","pending dept.","2023-06-09","2023-07-01","Y","Y","N"]
["Psychiatry","PST006",6,"Faculty with Major Leadership Functions","1. Major, large-scale projects plus significant/major administrative functions, or\n2. Chair or Executive Vice Chair.","2023-06-09","2023-07-01","Y",null,null,"ARC0372703","various Faculty changing APU","Y - inadequate","Y","N","2024-06-10","pending dept.","2023-06-09","2023-07-01","Y"]
["Radiation Medicine and Applied Sciences","RAO002",8,"Radiation Oncology Faculty (RAO)","Radiation Oncology Faculty","N","N","N","N","N","ARC0372726 ","no change - replacing expired","N/A","Y","Y","2024-04-26","Approved","2024-04-26","2024-07-01","N/A","Y","ARC0372726 "]
["Radiation Medicine and Applied Sciences","RAO005",5,"Radiation Oncology PhD Physicists (RAO)","Radiation Oncology Ph.D. Physicists","N","N","N","N","N","ARC0372726 ","no change - replacing expired","N/A","Y","Y","2024-04-26","Approved","2024-04-26","2024-07-01","N/A","Y","ARC0372726 "]
["Radiology","RAD001",8,"Diagnostic Division M.D. Faculty (RAD)","Diagnostic Division MDs.","N","2018-07-01","Y","Y","N","pending","no change - replacing expired","N","N","N","2024-04-25","pending dept.","N","2018-07-01","Y","Y","N"]
["Radiology","RAD003",2,"Diagnostic Division Ph.D. Faculty (RAD)","Diagnostic Division PhDs.","N","N","N","N","N","pending","no change - replacing expired","N","N","N","2024-04-25","pending dept.","N","N","N","N","N"]
["Radiology","RAD004",5,"Radiology fMRI Division Faculty","Radiology fMRI Division Faculty","N","N","N","N","N","pending","no change - replacing expired + less than 4 members","N","N","N","2024-04-25","pending dept.","N","N","N","N","N"]
["Radiology","RAD005",5,"Senior Research Imaging Faculty","Senior Research Imaging Faculty","2023-05-12","2023-07-01","N","Y","ARC0347363","pending","less than 4 members",null,null,null,null,"pending dept.","2023-05-12","2023-07-01","N","Y","ARC0347363"]
["SOM School-Wide APUs","SOM001",6,"Academic Deans/Directors/Department Chairs","Current and former Chairs, Academic Deans, Assoc Deans, Assistant Deans, Directors of Institutionally Mandated ORUs or Institutionally Mandated Non-ORU Centers in Health Sciences previously designated as ORUs in Health Sciences & Directors appointed to Health Sciences mandated administrative roles.","2023-10-27","7/1/2023\n\n9/1/23","Y","Y","ARC0362356",null,null,null,null,null,null,null,"2023-10-27","7/1/2023\n\n9/1/23","Y","Y","ARC0362356"]
["SOM School-Wide APUs","SOM002",7,"Surgical Chairs","Leadership in Depts that have surgical procedures.  Currently OPH, ORT, RPR, SUR.","N","N","N","N","N",null,null,null,null,null,null,null,"N","N","N","N","N"]
["SOM School-Wide APUs","SOM003",3,"Cross Department Nerve Injury APU","Investigators dedicated to the restoration of functional losses due to nerve injury with NIH, UCSD and VA Healthcare System support.","N","N","N","N","N",null,null,null,null,null,null,null,"N","N","N","N","N"]
["SOM School-Wide APUs","SOM004",0,"Physician Assistant Program APU","Faculty in the Physician Assistant program.",null,null,null,null,null,"pending","newly created SOM-wide APU for PA program","N/A","N","N",null,"pending APU profile form when we have Faculty assigned"]
["SOM School-Wide APUs","SOM005",1,"SOM Research & Teaching Faculty","SOM Faculty in clinical departments who are actively engaged in research and teaching without clinical duties (excluding PAE faculty). "]
["SOM School-Wide APUs","SOM009",9,"HS Mission Leaders APU","Thought Leaders in education, research, and clinical missions responsible for the leadership in strategy of the mssions and provide the academic counsel on mission direction, development, and implementation of programs and initiatives, and accountability for the successes and failure of the primary missions of HS.","N","N","N","N","N",null,null,null,null,null,null,null,"N","N","N","N","N"]
["SOM School-Wide APUs","SOMVA1",0,"Base UC/VA split appointment APU","Base School-wide APU for Faculty with split UC/VA appointment, or Faculty without an active independent research program, or Faculty who voluntarily choose to participate in this APU, but otherwise may be qualify for a higher APU.","2023-06-05","2023-07-01","Y","Y","N","ARC0372747","moving Dr. Bui from SOMVA1 to NEU003","Y","Y","Y","2024-05-02","Approved","2024-05-02","2024-07-01","Y","Y","ARC0372747"]
["Surgery","SUR001",7,"General & Pediatric Surgery Division Faculty (SUR)","Faculty in the Division of General Surgery who belong to MSCCP.",null,null,null,null,null,"ARC0361360","Dr. Bryan Sandler: SOMVA1 to SUR001","Y","Y","Y","2024-04-17","Approved","2024-04-17","2024-07-01","Y","Y","ARC0361360"]
["Surgery","SUR002",9,"Cardiothoracic Surgery Division Faculty (SUR)","Faculty in the Division of Cardiothoracic Surgery who belong to MSCCP.","N","N","N","N","N","ARC0372738","no change - replacing expired","N/A","N","N","2024-05-08","pending dept.","N","N","N","N","N"]
["Surgery","SUR004",7,"Otolaryngology Department Faculty","Clinically active faculty members in the Department of Otolaryngology",null,null,null,null,null,"ARC0361360","Drs. Charles Coffey and Deborah Watson: SOMVA 1 to SUR004","Y","Y","Y","2024-04-17","Approved","2024-04-17","2024-07-01","Y","Y","ARC0361360"]
["Surgery","SUR005",7,"Plastic Surgery Division Faculty (SUR)","Faculty in the Division of Plastic Surgery who belong to MSCCP.","N","N","N","N","N","ARC0372738","no change - replacing expired","N/A","N","N","2024-05-08","pending dept.","N","N","N","N","N"]
["Surgery","SUR006",8,"Trauma/Burn Division Faculty (SUR)","Faculty in the Division of Trauma/Burn who belong to MSCCP.","N","N","N","N","N","ARC0372738","no change - replacing expired","N/A","N","N","2024-05-08","pending dept.","N","N","N","N","N"]
["Surgery","SUR008",1,"Surgery PhD and non-clinically active MD Faculty","Surgery PhD faculty and MD faculty who are engaged primarily in research and teaching without a clinical practice.","2022-01-27","2022-07-01","Y","Y","ARC0314159",null,null,null,null,null,null,null,"2022-01-27","2022-07-01","Y","Y","ARC0314159"]
["Urology","SUR007",7,"Urology Division Faculty (SUR)","Faculty in the Division of Urology who belong to MSCCP.","2022-05-05","2022-07-01","Y","Y","ARC0326461","ARC0372855","no change - replacing expired","N/A","Y","Y","2024-06-03","Approved","2024-06-03","2024-07-01","N/A","Y","ARC0372855"]
["Herbert Wertheim School of Public Health and Human Longevity Science (HWSPH)","SPH000",0,"Basic Faculty APU","Faculty members in the HWSPH. L(P)SOE faculty.\n*** HWSPH faculty who qualify for a higher APU may voluntarily choose to belong to a lower APU.","2023-06-09","2023-07-01","Y","Y","ARC0347410",null,null,null,null,null,null,null,"2023-06-09","2023-07-01","Y","Y","ARC0347410"]
["Herbert Wertheim School of Public Health and Human Longevity Science (HWSPH)","SPH002",2,"Prior FMPH APU Faculty","Faculty with experience conducting public health research and/or teaching in a School of Medicine.\n*** HWSPH faculty who qualify for a higher APU may voluntarily choose to belong to a lower APU.","2023-06-09","2023-07-01","Y","Y","ARC0347410","ARC0372869","Moving Dr. Larsen from SPH002 to SPH005","Y","Y","Y","2024-06-06","Approved","2024-06-06","2024-07-01","Y","Y","ARC0372869"]
["Herbert Wertheim School of Public Health and Human Longevity Science (HWSPH)","SPH003",3,"Public Health Research and Teaching Faculty","Faculty members in the HWSPH that lead or participate in funded research and/or teach in the School's degree programs.\n*** HWSPH faculty who qualify for a higher APU may voluntarily choose to belong to a lower APU.","2023-06-09","2023-07-01","Y","Y","ARC0347410",null,null,null,null,null,null,null,"2023-06-09","2023-07-01","Y","Y","ARC0347410"]
["Herbert Wertheim School of Public Health and Human Longevity Science (HWSPH)","SPH005",5,"School Leadership","Faculty who hold, or have held, a high‐level leadership position in the HWSPH including Division Chiefs and degree program Directors, which include a significant amount of administrative service supporting the School. At the discretion of the Dean, this APU may be extended to HWSPH faculty who hold similar level leadership positions elsewhere in Health Sciences or the University.\n*** HWSPH faculty who qualify for a higher APU may voluntarily choose to belong to a lower APU.","2023-06-09","2023-07-01","Y","Y","ARC0347410","ARC0372869","Moving Dr. Pratt from SPH006 to SPH005\nMoving Dr. Larsen from SPH002 to SPH005","Y","Y","Y","2024-06-06","Approved","2024-06-06","2024-07-01","Y","Y","ARC0372869"]
["Herbert Wertheim School of Public Health and Human Longevity Science (HWSPH)","SPH006",6,"Assistant and Associate Deans, Dean","Faculty who hold, or have held, an Assistant Dean, Associate Dean, or Dean appointment in the HWSPH, which include a significant amount of administrative service supporting the School. At the discretion of the Dean, this APU may be extended to HWSPH faculty who hold senior leadership positions elsewhere in Health Sciences or the University such as Assisstant / Associate Vice Chancellor, Vice Chancellor, ORU Director.\n*** HWSPH faculty who qualify for a higher APU may voluntarily choose to belong to a lower APU.","2023-06-09","2023-07-01","Y","Y","ARC0347410","ARC0372869","Moving Dr. Pratt from SPH006 to SPH005","Y","Y","Y","2024-06-06","Approved","2024-06-06","2024-07-01","Y","Y","ARC0372869"]
["Skaggs School of Pharmacy and Pharmaceutical Sciences","SOP001",6,"Assistant and Associate Deans, Interim Department Chair, Department Chair and Dean","Must be an Assistant or Associate Dean, Interim Department Chair, Department Chair or Dean in the Skaggs School of Pharmacy and Pharmaceutical Sciences who supports the teaching, research, clinical and community service missions of the University. Activities include a large amount of administrative service supporting the School and the University. SSPPS faculty who qualify for a higher APU may voluntarily choose to belong to a lower APU","2023-05-11","2023-07-01","N","Y","N","ARC0372737 + ARC0371739 ","move Christina Mnatzaganian from SOP002 to SOP001, move Elizabeth Winzeler from PEDPED APU 3 to SOP001","Y","Y","Y","2024-06-10","Approved","2024-06-10","2024-07-01","Y","Y","ARC0372737 + ARC0371739 "]
["Skaggs School of Pharmacy and Pharmaceutical Sciences","SOP002",3,"SSPPS clinical + research + teaching","A faculty group in the Skaggs School of Pharmacy and Pharmaceutical Sciences (SSPPS) that conducts coordinated clinical (and/or patient care), and/or research and teaching activities.  These activities include training pharmacy, medical and graduate students in the classroom, research discussions and seminars, clinical research, clinical patient fairs, and work in the University free clinics and community clinics providing patient education and/or services, or being the PI on grants, and participation in centers and program projects.  SSPPS faculty who qualify for a higher APU may voluntarily choose to belong to a lower APU.","2023-06-16","2023-07-01","N","Y","N","ARC0372737","move Katharina Brandl from SOP003 to SOP002","Y","Y","Y","2024-06-10","Approved","2024-06-10","2024-07-01","Y","Y","ARC0372737"]
["Skaggs School of Pharmacy and Pharmaceutical Sciences","SOP003",0,"Basic Faculty APU","A group of faculty members in the Skaggs School of Pharmacy & Pharmaceutical Sciences (SSPPS) who are research oriented and/or contribute a significant portion of their effort to the teaching mission.  SSPPS faculty who qualify for a higher APU may voluntarily choose to belong to a lower APU.","2023-06-16","2023-07-01","Y","Y","N","ARC0372737","move Ruben Abagyan + William Gerwick from SOP002 to SOP003","Y","Y","Y","2024-06-10","Approved","2024-06-10","2024-07-01","Y","Y","ARC0372737"]

{"sheet":"FY24-FY25 Scales","index":4,"n_rows":204,"n_cols":12,"rows_kept":204,"cut":false,"hidden":true,"merged":[]}
["USE THIS TO VERIFY the X, X', and covered comp"]
["* May want to replace \"Full\" with \"Full to match the APU profile"]
[]
["Concatenate (roman numero + user \"Full\" instead of \"Full\")","Step (roman numero)","Concatenate","APU","Rank","Step","07/01 X","07/01 X' actual","07/01 Covered Comp","10/01 X","10/01 X' actual","10/01 Covered Comp"]
[{"$f":"CONCATENATE(E5,B5,D5)","v":"AssistantI0"},{"$f":"ROMAN(F5)","v":"I"},{"$f":"CONCATENATE(E5,F5,D5)","v":"Assistant10"},0,"Assistant",1,86500,0,{"$f":"SUM(G5:H5)","v":86500},90700,0,{"$f":"SUM(J5:K5)","v":90700}]
[{"$f":"CONCATENATE(E6,B6,D6)","v":"AssistantII0"},{"$f":"ROMAN(F6)","v":"II"},{"$f":"CONCATENATE(E6,F6,D6)","v":"Assistant20"},0,"Assistant",2,91300,0,91300,95400,0,{"$f":"SUM(J6:K6)","v":95400}]
[{"$f":"CONCATENATE(E7,B7,D7)","v":"AssistantIII0"},"III","Assistant30",0,"Assistant",3,96400,0,96400,100500,0,100500]
["AssistantIV0","IV","Assistant40",0,"Assistant",4,101700,0,101700,106000,0,106000]
["AssistantV0","V","Assistant50",0,"Assistant",5,107200,0,107200,111800,0,111800]
["AssistantVI0","VI","Assistant60",0,"Assistant",6,112800,0,112800,117600,0,117600]
["AssociateI0","I","Associate10",0,"Associate",1,107300,0,107300,111900,0,111900]
["AssociateII0","II","Associate20",0,"Associate",2,112900,0,112900,117700,0,117700]
["AssociateIII0","III","Associate30",0,"Associate",3,118900,0,118900,123900,0,123900]
["AssociateIV0","IV","Associate40",0,"Associate",4,125600,0,125600,130900,0,130900]
["AssociateV0","V","Associate50",0,"Associate",5,135300,0,135300,141100,0,141100]
["FullI0","I","Full10",0,"Full",1,125700,0,125700,131000,0,131000]
["FullII0","II","Full20",0,"Full",2,135400,0,135400,141200,0,141200]
["FullIII0","III","Full30",0,"Full",3,145900,0,145900,152100,0,152100]
["FullIV0","IV","Full40",0,"Full",4,156900,0,156900,163600,0,163600]
["FullV0","V","Full50",0,"Full",5,168700,0,168700,175900,0,175900]
["FullVI0","VI","Full60",0,"Full",6,181200,0,181200,189100,0,189100]
["FullVII0","VII","Full70",0,"Full",7,195100,0,195100,203500,0,203500]
["FullVIII0","VIII","Full80",0,"Full",8,210900,0,210900,219800,0,219800]
["FullIX0","IX","Full90",0,"Full",9,228600,0,228600,238300,0,238300]
["AssistantI1","I","Assistant11",1,"Assistant",1,86500,8300,94800,90700,9100,99800]
["AssistantII1","II","Assistant21",1,"Assistant",2,91300,8800,100100,95400,9600,105000]
["AssistantIII1","III","Assistant31",1,"Assistant",3,96400,9300,105700,100500,10100,110600]
["AssistantIV1","IV","Assistant41",1,"Assistant",4,101700,9800,111500,106000,10600,116600]
["AssistantV1","V","Assistant51",1,"Assistant",5,107200,10300,117500,111800,11200,123000]
["AssistantVI1","VI","Assistant61",1,"Assistant",6,112800,10800,123600,117600,11800,129400]
["AssociateI1","I","Associate11",1,"Associate",1,107300,10300,117600,111900,11200,123100]
["AssociateII1","II","Associate21",1,"Associate",2,112900,10800,123700,117700,11800,129500]
["AssociateIII1","III","Associate31",1,"Associate",3,118900,11400,130300,123900,12400,136300]
["AssociateIV1","IV","Associate41",1,"Associate",4,125600,12100,137700,130900,13100,144000]
["AssociateV1","V","Associate51",1,"Associate",5,135300,13000,148300,141100,14200,155300]
["FullI1","I","Full11",1,"Full",1,125700,12100,137800,131000,13100,144100]
["FullII1","II","Full21",1,"Full",2,135400,13000,148400,141200,14200,155400]
["FullIII1","III","Full31",1,"Full",3,145900,14000,159900,152100,15300,167400]
["FullIV1","IV","Full41",1,"Full",4,156900,15000,171900,163600,16400,180000]
["FullV1","V","Full51",1,"Full",5,168700,16200,184900,175900,17600,193500]
["FullVI1","VI","Full61",1,"Full",6,181200,17400,198600,189100,19000,208100]
["FullVII1","VII","Full71",1,"Full",7,195100,18700,213800,203500,20400,223900]
["FullVIII1","VIII","Full81",1,"Full",8,210900,20200,231100,219800,22000,241800]
["FullIX1","IX","Full91",1,"Full",9,228600,21900,250500,238300,23900,262200]
["AssistantI2","I","Assistant12",2,"Assistant",1,86500,16500,103000,90700,18200,108900]
["AssistantII2","II","Assistant22",2,"Assistant",2,91300,17500,108800,95400,19100,114500]
["AssistantIII2","III","Assistant32",2,"Assistant",3,96400,18500,114900,100500,20100,120600]
["AssistantIV2","IV","Assistant42",2,"Assistant",4,101700,19500,121200,106000,21200,127200]
["AssistantV2","V","Assistant52",2,"Assistant",5,107200,20500,127700,111800,22400,134200]
["AssistantVI2","VI","Assistant62",2,"Assistant",6,112800,21600,134400,117600,23600,141200]
["AssociateI2","I","Associate12",2,"Associate",1,107300,20500,127800,111900,22400,134300]
["AssociateII2","II","Associate22",2,"Associate",2,112900,21600,134500,117700,23600,141300]
["AssociateIII2","III","Associate32",2,"Associate",3,118900,22700,141600,123900,24800,148700]
["AssociateIV2","IV","Associate42",2,"Associate",4,125600,24100,149700,130900,26200,157100]
["AssociateV2","V","Associate52",2,"Associate",5,135300,25900,161200,141100,28300,169400]
["FullI2","I","Full12",2,"Full",1,125700,24100,149800,131000,26200,157200]
["FullII2","II","Full22",2,"Full",2,135400,25900,161300,141200,28300,169500]
["FullIII2","III","Full32",2,"Full",3,145900,27900,173800,152100,30500,182600]
["FullIV2","IV","Full42",2,"Full",4,156900,30000,186900,163600,32800,196400]
["FullV2","V","Full52",2,"Full",5,168700,32300,201000,175900,35200,211100]
["FullVI2","VI","Full62",2,"Full",6,181200,34700,215900,189100,37900,227000]
["FullVII2","VII","Full72",2,"Full",7,195100,37300,232400,203500,40700,244200]
["FullVIII2","VIII","Full82",2,"Full",8,210900,40400,251300,219800,44000,263800]
["FullIX2","IX","Full92",2,"Full",9,228600,43700,272300,238300,47700,286000]
["AssistantI3","I","Assistant13",3,"Assistant",1,86500,24700,111200,90700,27300,118000]
["AssistantII3","II","Assistant23",3,"Assistant",2,91300,26200,117500,95400,28700,124100]
["AssistantIII3","III","Assistant33",3,"Assistant",3,96400,27700,124100,100500,30200,130700]
["AssistantIV3","IV","Assistant43",3,"Assistant",4,101700,29200,130900,106000,31800,137800]
["AssistantV3","V","Assistant53",3,"Assistant",5,107200,30800,{"$f":"SUM(G69:H69)","v":138000},111800,33600,145400]
["AssistantVI3",{"$f":"ROMAN(F70)","v":"VI"},{"$f":"CONCATENATE(E70,F70,D70)","v":"Assistant63"},3,"Assistant",6,112800,32400,145200,117600,35400,{"$f":"SUM(J70:K70)","v":153000}]
[{"$f":"CONCATENATE(E71,B71,D71)","v":"AssociateI3"},"I","Associate13",3,"Associate",1,107300,30800,138100,111900,33600,145500]
["AssociateII3","II","Associate23",3,"Associate",2,112900,32400,145300,117700,35400,153100]
["AssociateIII3","III","Associate33",3,"Associate",3,118900,34100,153000,123900,37200,161100]
["AssociateIV3","IV","Associate43",3,"Associate",4,125600,36100,161700,130900,39300,170200]
["AssociateV3","V","Associate53",3,"Associate",5,135300,38900,174200,141100,42400,183500]
["FullI3","I","Full13",3,"Full",1,125700,36100,161800,131000,39300,170300]
["FullII3","II","Full23",3,"Full",2,135400,38900,174300,141200,42400,183600]
["FullIII3","III","Full33",3,"Full",3,145900,41900,187800,152100,45700,197800]
["FullIV3","IV","Full43",3,"Full",4,156900,45000,201900,163600,49100,212700]
["FullV3","V","Full53",3,"Full",5,168700,48400,217100,175900,52800,228700]
["FullVI3","VI","Full63",3,"Full",6,181200,52000,233200,189100,56800,245900]
["FullVII3","VII","Full73",3,"Full",7,195100,56000,251100,203500,61100,264600]
["FullVIII3","VIII","Full83",3,"Full",8,210900,60500,271400,219800,66000,285800]
["FullIX3","IX","Full93",3,"Full",9,228600,65600,294200,238300,71500,309800]
["AssistantI4","I","Assistant14",4,"Assistant",1,86500,32900,119400,90700,36300,127000]
["AssistantII4","II","Assistant24",4,"Assistant",2,91300,34900,126200,95400,38200,133600]
["AssistantIII4","III","Assistant34",4,"Assistant",3,96400,36900,133300,100500,40200,140700]
["AssistantIV4","IV","Assistant44",4,"Assistant",4,101700,38900,140600,106000,42400,148400]
["AssistantV4","V","Assistant54",4,"Assistant",5,107200,41000,148200,111800,44800,156600]
["AssistantVI4","VI","Assistant64",4,"Assistant",6,112800,43200,156000,117600,47100,164700]
["AssociateI4","I","Associate14",4,"Associate",1,107300,41000,148300,111900,44800,156700]
["AssociateII4","II","Associate24",4,"Associate",2,112900,43200,156100,117700,47100,164800]
["AssociateIII4","III","Associate34",4,"Associate",3,118900,45400,164300,123900,49600,173500]
["AssociateIV4","IV","Associate44",4,"Associate",4,125600,48100,173700,130900,52400,183300]
["AssociateV4","V","Associate54",4,"Associate",5,135300,51800,187100,141100,56500,197600]
["FullI4","I","Full14",4,"Full",1,125700,48100,173800,131000,52400,183400]
["FullII4","II","Full24",4,"Full",2,135400,51800,187200,141200,56500,197700]
["FullIII4","III","Full34",4,"Full",3,145900,55800,201700,152100,60900,213000]
["FullIV4","IV","Full44",4,"Full",4,156900,60000,216900,163600,65500,229100]
["FullV4","V","Full54",4,"Full",5,168700,64500,233200,175900,70400,246300]
["FullVI4","VI","Full64",4,"Full",6,181200,69300,250500,189100,75700,264800]
["FullVII4","VII","Full74",4,"Full",7,195100,74600,269700,203500,81400,284900]
["FullVIII4","VIII","Full84",4,"Full",8,210900,80700,291600,219800,88000,307800]
["FullIX4","IX","Full94",4,"Full",9,228600,87400,316000,238300,95400,333700]
["AssistantI5","I","Assistant15",5,"Assistant",1,86500,41100,127600,90700,45400,136100]
["AssistantII5","II","Assistant25",5,"Assistant",2,91300,43600,134900,95400,47700,143100]
["AssistantIII5","III","Assistant35",5,"Assistant",3,96400,46100,142500,100500,50300,150800]
["AssistantIV5","IV","Assistant45",5,"Assistant",4,101700,48600,150300,106000,53000,159000]
["AssistantV5","V","Assistant55",5,"Assistant",5,107200,51300,158500,111800,56000,167800]
["AssistantVI5","VI","Assistant65",5,"Assistant",6,112800,53900,166700,117600,58900,176500]
["AssociateI5","I","Associate15",5,"Associate",1,107300,51300,158600,111900,56000,167900]
["AssociateII5","II","Associate25",5,"Associate",2,112900,53900,166800,117700,58900,176600]
["AssociateIII5","III","Associate35",5,"Associate",3,118900,56700,175600,123900,62000,185900]
["AssociateIV5","IV","Associate45",5,"Associate",4,125600,60100,185700,130900,65500,196400]
["AssociateV5","V","Associate55",5,"Associate",5,135300,64700,200000,141100,70600,211700]
["FullI5","I","Full15",5,"Full",1,125700,60100,185800,131000,65500,196500]
["FullII5","II","Full25",5,"Full",2,135400,64700,200100,141200,70600,211800]
["FullIII5","III","Full35",5,"Full",3,145900,69700,215600,152100,76100,228200]
["FullIV5","IV","Full45",5,"Full",4,156900,75000,231900,163600,81800,245400]
["FullV5","V","Full55",5,"Full",5,168700,80600,249300,175900,88000,263900]
["FullVI5","VI","Full65",5,"Full",6,181200,86600,267800,189100,94600,283700]
["FullVII5","VII","Full75",5,"Full",7,195100,93300,288400,203500,101800,305300]
["FullVIII5","VIII","Full85",5,"Full",8,210900,100800,311700,219800,109900,329700]
["FullIX5","IX","Full95",5,"Full",9,228600,109300,337900,238300,119200,357500]
["AssistantI6","I","Assistant16",6,"Assistant",1,86500,53500,140000,90700,59000,149700]
["AssistantII6","II","Assistant26",6,"Assistant",2,91300,56700,148000,95400,62100,157500]
["AssistantIII6","III","Assistant36",6,"Assistant",3,96400,59900,156300,100500,65400,165900]
["AssistantIV6","IV","Assistant46",6,"Assistant",4,101700,63200,164900,106000,68900,174900]
["AssistantV6","V","Assistant56",6,"Assistant",5,107200,66700,173900,111800,72800,184600]
["AssistantVI6","VI","Assistant66",6,"Assistant",6,112800,70100,182900,117600,76600,194200]
["AssociateI6","I","Associate16",6,"Associate",1,107300,66700,174000,111900,72800,184700]
["AssociateII6","II","Associate26",6,"Associate",2,112900,70100,183000,117700,76600,194300]
["AssociateIII6","III","Associate36",6,"Associate",3,118900,73800,{"$f":"SUM(G133:H133)","v":192700},123900,80600,204500]
["AssociateIV6",{"$f":"ROMAN(F134)","v":"IV"},{"$f":"CONCATENATE(E134,F134,D134)","v":"Associate46"},6,"Associate",4,125600,78200,203800,130900,85200,{"$f":"SUM(J134:K134)","v":216100}]
[{"$f":"CONCATENATE(E135,B135,D135)","v":"AssociateV6"},"V","Associate56",6,"Associate",5,135300,84200,219500,141100,91800,232900]
["FullI6","I","Full16",6,"Full",1,125700,78200,203900,131000,85200,216200]
["FullII6","II","Full26",6,"Full",2,135400,84200,219600,141200,91800,233000]
["FullIII6","III","Full36",6,"Full",3,145900,90700,236600,152100,98900,251000]
["FullIV6","IV","Full46",6,"Full",4,156900,97500,254400,163600,106400,270000]
["FullV6","V","Full56",6,"Full",5,168700,104800,273500,175900,114400,290300]
["FullVI6","VI","Full66",6,"Full",6,181200,112600,293800,189100,123000,312100]
["FullVII6","VII","Full76",6,"Full",7,195100,121300,316400,203500,132300,335800]
["FullVIII6","VIII","Full86",6,"Full",8,210900,131100,342000,219800,142900,362700]
["FullIX6","IX","Full96",6,"Full",9,228600,142100,370700,238300,154900,393200]
["AssistantI7","I","Assistant17",7,"Assistant",1,86500,65800,152300,90700,72600,163300]
["AssistantII7","II","Assistant27",7,"Assistant",2,91300,69700,161000,95400,76400,171800]
["AssistantIII7","III","Assistant37",7,"Assistant",3,96400,73700,170100,100500,80400,180900]
["AssistantIV7","IV","Assistant47",7,"Assistant",4,101700,77800,179500,106000,84800,190800]
["AssistantV7","V","Assistant57",7,"Assistant",5,107200,82000,189200,111800,89600,201400]
["AssistantVI7","VI","Assistant67",7,"Assistant",6,112800,86300,199100,117600,94200,211800]
["AssociateI7","I","Associate17",7,"Associate",1,107300,82000,189300,111900,89600,201500]
["AssociateII7","II","Associate27",7,"Associate",2,112900,86300,199200,117700,94200,211900]
["AssociateIII7","III","Associate37",7,"Associate",3,118900,90800,209700,123900,99200,223100]
["AssociateIV7","IV","Associate47",7,"Associate",4,125600,96200,221800,130900,104800,235700]
["AssociateV7","V","Associate57",7,"Associate",5,135300,103600,238900,141100,113000,254100]
["FullI7","I","Full17",7,"Full",1,125700,96200,221900,131000,104800,235800]
["FullII7","II","Full27",7,"Full",2,135400,103600,239000,141200,113000,254200]
["FullIII7","III","Full37",7,"Full",3,145900,111600,257500,152100,121700,273800]
["FullIV7","IV","Full47",7,"Full",4,156900,120000,276900,163600,130900,294500]
["FullV7","V","Full57",7,"Full",5,168700,128900,297600,175900,140800,316700]
["FullVI7","VI","Full67",7,"Full",6,181200,138600,319800,189100,151300,340400]
["FullVII7","VII","Full77",7,"Full",7,195100,149200,344300,203500,162800,366300]
["FullVIII7","VIII","Full87",7,"Full",8,210900,161300,372200,219800,175900,395700]
["FullIX7","IX","Full97",7,"Full",9,228600,174800,403400,238300,190700,429000]
["AssistantI8","I","Assistant18",8,"Assistant",1,86500,82200,168700,90700,90700,181400]
["AssistantII8","II","Assistant28",8,"Assistant",2,91300,87100,178400,95400,95400,190800]
["AssistantIII8","III","Assistant38",8,"Assistant",3,96400,92100,188500,100500,100500,201000]
["AssistantIV8","IV","Assistant48",8,"Assistant",4,101700,97200,198900,106000,106000,212000]
["AssistantV8","V","Assistant58",8,"Assistant",5,107200,102500,209700,111800,111900,223700]
["AssistantVI8","VI","Assistant68",8,"Assistant",6,112800,107800,220600,117600,117700,235300]
["AssociateI8","I","Associate18",8,"Associate",1,107300,102500,209800,111900,111900,223800]
["AssociateII8","II","Associate28",8,"Associate",2,112900,107800,220700,117700,117700,235400]
["AssociateIII8","III","Associate38",8,"Associate",3,118900,113400,232300,123900,123900,247800]
["AssociateIV8","IV","Associate48",8,"Associate",4,125600,120200,245800,130900,131000,261900]
["AssociateV8","V","Associate58",8,"Associate",5,135300,129400,264700,141100,141200,282300]
["FullI8","I","Full18",8,"Full",1,125700,120200,245900,131000,131000,262000]
["FullII8","II","Full28",8,"Full",2,135400,129400,264800,141200,141200,282400]
["FullIII8","III","Full38",8,"Full",3,145900,139400,285300,152100,152100,304200]
["FullIV8","IV","Full48",8,"Full",4,156900,149900,306800,163600,163600,327200]
["FullV8","V","Full58",8,"Full",5,168700,161100,329800,175900,175900,351800]
["FullVI8","VI","Full68",8,"Full",6,181200,173200,354400,189100,189100,378200]
["FullVII8","VII","Full78",8,"Full",7,195100,186500,381600,203500,203500,407000]
["FullVIII8","VIII","Full88",8,"Full",8,210900,201600,412500,219800,219800,439600]
["FullIX8","IX","Full98",8,"Full",9,228600,218500,447100,238300,238300,476600]
["AssistantI9","I","Assistant19",9,"Assistant",1,86500,102800,189300,90700,113400,204100]
["AssistantII9","II","Assistant29",9,"Assistant",2,91300,108900,200200,95400,119300,214700]
["AssistantIII9","III","Assistant39",9,"Assistant",3,96400,115200,211600,100500,125700,226200]
["AssistantIV9","IV","Assistant49",9,"Assistant",4,101700,121500,223200,106000,132500,238500]
["AssistantV9","V","Assistant59",9,"Assistant",5,107200,128200,235400,111800,139900,251700]
["AssistantVI9","VI","Assistant69",9,"Assistant",6,112800,134800,247600,117600,147200,264800]
["AssociateI9","I","Associate19",9,"Associate",1,107300,128200,235500,111900,139900,251800]
["AssociateII9","II","Associate29",9,"Associate",2,112900,134800,247700,117700,147200,264900]
["AssociateIII9","III","Associate39",9,"Associate",3,118900,141800,260700,123900,154900,278800]
["AssociateIV9","IV","Associate49",9,"Associate",4,125600,150300,275900,130900,163800,294700]
["AssociateV9","V","Associate59",9,"Associate",5,135300,161800,297100,141100,176500,317600]
["FullI9","I","Full19",9,"Full",1,125700,150300,276000,131000,163800,294800]
["FullII9","II","Full29",9,"Full",2,135400,161800,{"$f":"SUM(G197:H197)","v":297200},141200,176500,317700]
["FullIII9",{"$f":"ROMAN(F198)","v":"III"},{"$f":"CONCATENATE(E198,F198,D198)","v":"Full39"},9,"Full",3,145900,174300,320200,152100,190200,{"$f":"SUM(J198:K198)","v":342300}]
[{"$f":"CONCATENATE(E199,B199,D199)","v":"FullIV9"},"IV","Full49",9,"Full",4,156900,187400,344300,163600,204500,368100]
["FullV9","V","Full59",9,"Full",5,168700,201400,370100,175900,219900,395800]
["FullVI9","VI","Full69",9,"Full",6,181200,216500,397700,189100,236400,425500]
["FullVII9","VII","Full79",9,"Full",7,195100,233200,428300,203500,254400,457900]
["FullVIII9","VIII","Full89",9,"Full",8,210900,252000,462900,219800,274800,494600]
["FullIX9","IX","Full99",9,"Full",9,228600,273200,501800,238300,297900,536200]

{"sheet":"APU Scale","index":5,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Scale","Multiplier"]
[0,1]
[1,1.1000000000000001]
[2,1.2]
[3,1.3]
[4,1.4]
[5,1.5]
[6,1.65]
[7,1.8]
[8,2]
[9,2.25]